Problem creating mySQL table with php...
Posted: Wed Oct 26, 2011 10:57 pm
Hi all,
The following code is giving me fits. I'm sure it's my syntax that is incorrect but I don't know where. Any help would be greatly appreciated.
The following code is giving me fits. I'm sure it's my syntax that is incorrect but I don't know where. Any help would be greatly appreciated.
Code: Select all
<?php
$query_users = "SELECT * FROM Users.members";
$result = mysql_query($query_users);
$r_n = 1;
while ($row = mysql_fetch_assoc($result))
{
$mbr_log = $row[`login`];
echo $r_n," ",$row['login'],"<br />";
[color=red]mysql_query("CREATE TABLE Contacts.'$mbr_log' SELECT * FROM Contacts.AB_Macbook")[/color]
//echo " ";
//echo "<td>",$row['login_time'];
//echo " ";
$r_n++;
}
?>