Page 1 of 1

whats wrong with this query?

Posted: Sun Jul 14, 2002 1:25 am
by Jose Arce

Code: Select all

$query="CREATE TABLE $name(id INT(4) NOT NULL AUTO_INCREMENT,asd VARCHAR(4),asd1 VARCHAR(10), asd2 VARCHAR(10),asd3 VARCHAR(10), asd3 VARCHAR(10), KEY (id))";
$create=mysql_query($query) or die("Falló la petición");

Anyone?

Thx:D

...

Posted: Sun Jul 14, 2002 7:07 am
by QWERTY
I dont' realy know, but try with quotes around $name.

Code: Select all

'$name'
And to this:

Code: Select all

$create=mysql_query($query) or die("Falló la petición" . mysql_error());

Posted: Mon Jul 15, 2002 3:47 am
by Wayne
You have used the column name asd3 twice.