making new tables

[MatttWithOneT]

this is the code i have to make a table in my database:

$table = mysql_query("CREATE TABLE poop (age INT, name VARCHAR[15])");
if(mysql_query($table))
{ echo("<P>Created successful!" .
"</P>");}
if(@!mysql_query($table))
{ echo("<P>Error: " .
mysql_error() .
"</P>");}

.. but that wont work. It comes up with the error: Query is empty. even though the database IS accessed correctly. Please I'd love some insight.:rolleyes:

[majik-sheff]

Once you've called msql_query and assigned the result to a variable, the variable then represents a resource that points to the actual result. There are two ways you can approach this problem, the first would be to print the error and continue on with the script anyway. To do this you would use code like this:

$table = mysql_query("CREATE TABLE poop (age INT, name VARCHAR[15])");
if(is_resource($table)) {
echo "<P>Created successful!</P>";
} else {
echo("<P>Error: ". mysql_error() . "</P>");
}

However, if you want to kill the script if there's an error you can use considerably less code:

$table = mysql_query("CREATE TABLE poop (age INT, name VARCHAR[15])")
or die("Error: " . mysql_error() . "</P>");

Check out the manual on mysql and resources for more information