[thelist] creating a mySQL table dynamically in php

On 1/6/03 4:02 PM, "Tom Dell'Aringa" <pixelmech at yahoo.comrote:

> $sql  = " CREATE TABLE test  (";
> $sql .= "   pid    VARCHAR(12), ";
> $sql .= "   qty    VARCHAR(12), ";
> $sql .= " );  ";
>
> if(!@mysql_query($sql))
> {
> print "Err" . mysql_error();
> exit();
> }

set your last line to:

 $sql .= " );";

a little tip : do not feed white spaces after the semicolon in your queries
... you will always get errors!

hans!