Jump to content


Photo

how can i make more then one table in one install file?


  • Please log in to reply
18 replies to this topic

#1 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 02:59 PM

like as you can see when you create forums u need a install file so its easier on you right? So how can i make a intall.php file that can create more then one table?
Dont Piss me Off today

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 18 July 2006 - 03:18 PM

Create an array of all the tables needed to be installed. The use foreach loop to create the table eg:
$tables = array();

//table 1
$tables[] = "CREATE TABLE table1 (
-- table1 fields here
);";

// table 2
$tables[] = "CREATE TABLE table2 (
-- table2 fields here
);";

// connect to db here

// now loop through our table array to create our tables:
foreach($tables as $table => $query)
{
  // perform our query
  mysql_query($queryl) or die(mysql_error());
}

Thats is basically how got about create more than one table automatically.

#3 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 03:25 PM

foreach($tables as $table => $query)

^where is the $table varible can u verify sorry i never made multiple tables or is it a spelling error
Dont Piss me Off today

#4 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 03:25 PM

If you have MySQL 4.1.3+ and the MySQLi extension compiled with your PHP config, you can do the following:

<?php
$sql = 'CREATE TABLE table1 (
/* FIELDS HERE */
);';

$sql .= 'CREATE TABLE table2 (
/* FIELDS HERE */
);';
$mysqli = new mysqli('host','username','pass','db');
$i=1;

if ($mysqli->multi_query($sql)) {
     do {
          if ($result = $mysqli->store_result()) {
               echo 'Created table '.$i.'<br />';
          } else {
               echo 'Could not create table '.$i.'<br />';
          }
          $result->close();
          $i++;
     } while ($mysqli->next_result());
} // end if
$mysqli->close();
?>

Zend Certified Engineer (ZEND001989)
www.willfitch.com

#5 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 03:30 PM

MySQL version  4.1.19-standard is my mysql version

whats mysqli and how do i get the extention ?

foreach($tables as $table => $query)

can you plz edit your first example?
Dont Piss me Off today

#6 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 03:33 PM

First, check to ensure you don't already have it:
<?php
if (function_exists('mysqli_connect')) {
     echo 'I have it!';
} else {
     echo "I don't have it.";
}
?>

If you do, great!  Start using it!  If you don't, and you are on *nix, you will have to compile PHP with:

--with-mysqli=/path/to/mysql/dir/bin/mysql_config

If you don't have it and you are on Windows, simply edit the php.ini file and add the following during the extension loads:

extension=php_mysqli.dll
Zend Certified Engineer (ZEND001989)
www.willfitch.com

#7 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 03:37 PM

http://xizionz.vecto...m/mysqltest.php

tehe :)

im guessing i can use your second one right?
Dont Piss me Off today

#8 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 03:49 PM

LOL

Looks like you're good to go!
Zend Certified Engineer (ZEND001989)
www.willfitch.com

#9 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 04:09 PM

i got a problem mate -_-

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/scheols/public_html/forumz/dbcreate.php on line 5


<?php
$sql = 'CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `msn` varchar(250) NOT NULL default 'Not Specified',
  `aim` varchar(250) NOT NULL default 'Not Specified',
  `posts` int(10) NOT NULL default '0',
  `location` varchar(36) NOT NULL default 'Not Specified',
  `online` varchar(12) default NULL,
  `level` int(1) default '1',
  `validated` varchar(50) NOT NULL default '0',
  `val_num` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
)';
$sql .='CREATE TABLE `topics` (
  `id` int(9) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
  `fid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `replies` int(9) NOT NULL default '0',
  `views` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)';
$sql .='CREATE TABLE `replies` (
  `id` int(4) NOT NULL auto_increment,
  `tid` int(9) NOT NULL default '0',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
)';
$sql .='CREATE TABLE `pmessages` (
  `title` varchar(255) NOT NULL default 'Untitled Message',
  `message` text NOT NULL,
  `touser` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `unread` varchar(255) NOT NULL default 'unread',
  `date` date NOT NULL default '0000-00-00',
  `id` int(15) NOT NULL auto_increment,
  `reply` varchar(15) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
)';
$sql .='CREATE TABLE `forums` (
  `id` int(4) NOT NULL auto_increment,
  `cid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` longtext NOT NULL,
  `last_post_title` varchar(255) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `topics` int(9) NOT NULL default '0',
  `replies` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)';
$sql .='CREATE TABLE `catagories` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `banner` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
)';
include "nconfig.php";
$mysqli = new mysqli('localhost','$username','$pass','$db');
$i=1;
if ($mysqli->multi_query($sql)) {
     do {
          if ($result = $mysqli->store_result()) {
               echo 'Created table '.$i.'<br />';
          } else {
               echo 'Could not create table '.$i.'<br />';
          }
          $result->close();
          $i++;
     } while ($mysqli->next_result());
} // end if
$mysqli->close();
?>

`password` varchar(255) NOT NULL default '',


Dont Piss me Off today

#10 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 04:12 PM

Yup, you do.  On line five, you used '' for default ''.  There are actually many parse errors. lol.  Do this:

<?php
$sql = "CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `msn` varchar(250) NOT NULL default 'Not Specified',
  `aim` varchar(250) NOT NULL default 'Not Specified',
  `posts` int(10) NOT NULL default '0',
  `location` varchar(36) NOT NULL default 'Not Specified',
  `online` varchar(12) default NULL,
  `level` int(1) default '1',
  `validated` varchar(50) NOT NULL default '0',
  `val_num` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `topics` (
  `id` int(9) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
  `fid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `replies` int(9) NOT NULL default '0',
  `views` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `replies` (
  `id` int(4) NOT NULL auto_increment,
  `tid` int(9) NOT NULL default '0',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `pmessages` (
  `title` varchar(255) NOT NULL default 'Untitled Message',
  `message` text NOT NULL,
  `touser` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `unread` varchar(255) NOT NULL default 'unread',
  `date` date NOT NULL default '0000-00-00',
  `id` int(15) NOT NULL auto_increment,
  `reply` varchar(15) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `forums` (
  `id` int(4) NOT NULL auto_increment,
  `cid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` longtext NOT NULL,
  `last_post_title` varchar(255) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `topics` int(9) NOT NULL default '0',
  `replies` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `catagories` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `banner` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
include "nconfig.php";
$mysqli = new mysqli('localhost','$username','$pass','$db');
$i=1;
if ($mysqli->multi_query($sql)) {
     do {
          if ($result = $mysqli->store_result()) {
               echo 'Created table '.$i.'<br />';
          } else {
               echo 'Could not create table '.$i.'<br />';
          }
          $result->close();
          $i++;
     } while ($mysqli->next_result());
} // end if
$mysqli->close();
?>

Zend Certified Engineer (ZEND001989)
www.willfitch.com

#11 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 04:21 PM

i get a whole new list or errors now

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/scheols/public_html/forumz/nconfig.php on line 10

Warning: mysqli::mysqli() [function.mysqli-mysqli]: (28000/1045): Access denied for user '$username'@'localhost' (using password: YES) in /home/scheols/public_html/forumz/dbcreate.php on line 66

Warning: mysqli::multi_query() [function.mysqli-multi-query]: Couldn't fetch mysqli in /home/scheols/public_html/forumz/dbcreate.php on line 68

Warning: mysqli::close() [function.mysqli-close]: Couldn't fetch mysqli in /home/scheols/public_html/forumz/dbcreate.php on line 79


`location` varchar(36) NOT NULL default 'Not Specified',

$mysqli = new mysqli('localhost','$username','$pass','$db');

if ($mysqli->multi_query($sql)) {

$mysqli->close();


i dont understand these errors since i dont know mysqli so maybe you can still help.
Dont Piss me Off today

#12 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 04:42 PM

Yes.

You have your variables for the connection:

$mysqli = new mysqli('localhost','$username','$pass','$db');
inside single quotes.
Use this:


$mysqli = new mysqli('localhost',$username,$pass,$db);
Zend Certified Engineer (ZEND001989)
www.willfitch.com

#13 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 05:13 PM

so humm the page is not a blank page? heres what i came up with and nothen happened:

<?php
$sql = "CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `msn` varchar(250) NOT NULL default 'Not Specified',
  `aim` varchar(250) NOT NULL default 'Not Specified',
  `posts` int(10) NOT NULL default '0',
  `location` varchar(36) NOT NULL default 'Not Specified',
  `online` varchar(12) default NULL,
  `level` int(1) default '1',
  `validated` varchar(50) NOT NULL default '0',
  `val_num` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `topics` (
  `id` int(9) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
  `fid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `replies` int(9) NOT NULL default '0',
  `views` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `replies` (
  `id` int(4) NOT NULL auto_increment,
  `tid` int(9) NOT NULL default '0',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `pmessages` (
  `title` varchar(255) NOT NULL default 'Untitled Message',
  `message` text NOT NULL,
  `touser` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `unread` varchar(255) NOT NULL default 'unread',
  `date` date NOT NULL default '0000-00-00',
  `id` int(15) NOT NULL auto_increment,
  `reply` varchar(15) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `forums` (
  `id` int(4) NOT NULL auto_increment,
  `cid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` longtext NOT NULL,
  `last_post_title` varchar(255) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `topics` int(9) NOT NULL default '0',
  `replies` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `catagories` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `banner` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
include "nconfig.php";
$mysqli = new mysqli('localhost',$username,$pass,$db);
$i=1;
if ($mysqli->multi_query($sql)) {
     do {
          if ($result = $mysqli->store_result()) {
               echo 'Created table '.$i.'<br />';
          } else {
               echo 'Could not create table '.$i.'<br />';
          }
          $result->close();
          $i++;
     } while ($mysqli->next_result());
} // end if
$mysqli->close();
?>

Dont Piss me Off today

#14 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 05:15 PM

Try this for error handling purposes:
<?php
$sql = "CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `msn` varchar(250) NOT NULL default 'Not Specified',
  `aim` varchar(250) NOT NULL default 'Not Specified',
  `posts` int(10) NOT NULL default '0',
  `location` varchar(36) NOT NULL default 'Not Specified',
  `online` varchar(12) default NULL,
  `level` int(1) default '1',
  `validated` varchar(50) NOT NULL default '0',
  `val_num` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `topics` (
  `id` int(9) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
  `fid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `replies` int(9) NOT NULL default '0',
  `views` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `replies` (
  `id` int(4) NOT NULL auto_increment,
  `tid` int(9) NOT NULL default '0',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `pmessages` (
  `title` varchar(255) NOT NULL default 'Untitled Message',
  `message` text NOT NULL,
  `touser` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `unread` varchar(255) NOT NULL default 'unread',
  `date` date NOT NULL default '0000-00-00',
  `id` int(15) NOT NULL auto_increment,
  `reply` varchar(15) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `forums` (
  `id` int(4) NOT NULL auto_increment,
  `cid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` longtext NOT NULL,
  `last_post_title` varchar(255) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `topics` int(9) NOT NULL default '0',
  `replies` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)";
$sql .="CREATE TABLE `catagories` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `banner` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
)";
include "nconfig.php";
$mysqli = new mysqli('localhost',$username,$pass,$db);
$i=1;
if ($mysqli->multi_query($sql)) {
     do {
          if ($result = $mysqli->store_result()) {
               echo 'Created table '.$i.'<br />';
          } else {
               echo 'Could not create table '.$i.'<br />';
          }
          $result->close();
          $i++;
     } while ($mysqli->next_result());
} else {
     die('DB ERROR: '.$mysqli->error);
}
$mysqli->close();
?>

Zend Certified Engineer (ZEND001989)
www.willfitch.com

#15 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 05:17 PM

DB ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `topics` ( `id` int(9) NOT NULL auto_increment, `timestamp` tim' at line 15

thats the error not sure cant wait to finnaly fix this problem thanks will
Dont Piss me Off today

#16 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 05:22 PM

Ok, I see your issues.  Place a semi-colon after each "CREATE TABLE" statement:

<?php
$sql = "CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `msn` varchar(250) NOT NULL default 'Not Specified',
  `aim` varchar(250) NOT NULL default 'Not Specified',
  `posts` int(10) NOT NULL default '0',
  `location` varchar(36) NOT NULL default 'Not Specified',
  `online` varchar(12) default NULL,
  `level` int(1) default '1',
  `validated` varchar(50) NOT NULL default '0',
  `val_num` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
);";
$sql .="CREATE TABLE `topics` (
  `id` int(9) NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
  `fid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `replies` int(9) NOT NULL default '0',
  `views` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);";
$sql .="CREATE TABLE `replies` (
  `id` int(4) NOT NULL auto_increment,
  `tid` int(9) NOT NULL default '0',
  `post` longtext NOT NULL,
  `username` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
);";
$sql .="CREATE TABLE `pmessages` (
  `title` varchar(255) NOT NULL default 'Untitled Message',
  `message` text NOT NULL,
  `touser` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `unread` varchar(255) NOT NULL default 'unread',
  `date` date NOT NULL default '0000-00-00',
  `id` int(15) NOT NULL auto_increment,
  `reply` varchar(15) NOT NULL default 'no',
  PRIMARY KEY  (`id`)
);";
$sql .="CREATE TABLE `forums` (
  `id` int(4) NOT NULL auto_increment,
  `cid` int(4) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` longtext NOT NULL,
  `last_post_title` varchar(255) NOT NULL default '',
  `last_post_username` varchar(32) NOT NULL default '',
  `topics` int(9) NOT NULL default '0',
  `replies` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);";
$sql .="CREATE TABLE `catagories` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `banner` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
);";
include "nconfig.php";
$mysqli = new mysqli('localhost',$username,$pass,$db);
$i=1;
if ($mysqli->multi_query($sql)) {
     do {
          if ($result = $mysqli->store_result()) {
               echo 'Created table '.$i.'<br />';
          } else {
               echo 'Could not create table '.$i.'<br />';
          }
          $result->close();
          $i++;
     } while ($mysqli->next_result());
} else {
     die('DB ERROR: '.$mysqli->error);
}
$mysqli->close();
?>

When using the multi_query method, you must delimit each query.
Zend Certified Engineer (ZEND001989)
www.willfitch.com

#17 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 05:29 PM

although it creates tables i still get this error

Could not create table 1

Fatal error: Call to a member function close() on a non-object in /home/scheols/public_html/forumz/install.php on line 75


$result->close();



also Thank you man once this lil bug is fixed you saved my life :)
Dont Piss me Off today

#18 scheols

scheols
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 18 July 2006 - 05:57 PM

bump sorry for bumping
Dont Piss me Off today

#19 willfitch

willfitch
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationNew Hope, PA

Posted 18 July 2006 - 07:16 PM

Glad to see it works.

Ok, take out the $result->close() portion, and you will be good to go. :)
Zend Certified Engineer (ZEND001989)
www.willfitch.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users