MySQL error !!!
Okay I have this MYSQL code, but FOR some REASON ITS NOT WORKING!
This is the code,, what is wrong???
//Making mysql connection
//Creating the table for member control
$query="CREATE TABLE members (user_id MEDIUMINT(5) NOT NULL AUTO_INCREMENT);";
//Making mysql query
$result = @mysql_query($query);
echo("The MySQL Table 'members' has been created. You may now populate it!");
echo("MySQL has a problem");
The mysql_connection.php script makes the connection to the database. This works, since it was tested. and it makes the connection. Every time I try to make the table members with the user_id in it, it keeps showing MySQL has a problem.
Please any help is greatly appreciated!!!