[thelist] php+mySQL

Jay Blanchard jay.blanchard at niicommunications.com
Thu May 23 13:57:01 CDT 2002


[snip]
Don't forget to concat variables in these statements, and make sure the user
has grants to create, and make sure to flush!

mysql_query("CREATE TABLE $db_tablename ($name char(20) NOT
NULL,$description char(50) NOT NULL,$version char(20) NOT NULL)");

[/snip]

Try concatting the variables;

mysql_query("CREATE TABLE " . $db_tablename . " (" . $name . " char(20) NOT
NULL, " . $description . "char(50) NOT NULL, " . $version . "char(20) NOT
NULL)");

Jay







More information about the thelist mailing list