Hello fellow PHPers...
This is my first post and I am not sure if I am even posting to the right
group, so please bear with me here. I have run into a seriously stubborn
problem. I am trying to creat a table using the following code...but here is
the catch: it only create the first table and not the others. I have tried
using the "while" statement instead of the "for" and ther resut is the same.
It just does not want to go past the first record. Everybody i have tried to
get help from outside the newsgroup has assured me the code is correct, so
why is it not working? Please help. Thank you.
=================== START CODE ===================
$cmnd="select * from clients";
$syst=mysql_query($cmnd) or die("CANNOT LOCATE CLIENT INFORMATION");
$rows=mysql_num_rows($syst); // there are 15 rows in the table
for ($i=1; $i<=$rows; $i++)
{
$line=mysql_fetch_row($syst);
$cmnd="create table if not exists $line[0] (sys_name varchar(20));";
$syst=mysql_query($cmnd) or die("COULD NOT CREATE TABLE");
}
==================== END CODE ====================
--
Tony Tzankoff
http://www.tzankoff.com
=========================
--
PHP Documentation Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
