Creating a MySQL table
Posted: Tue Feb 15, 2005 4:03 pm
Okay, I am at a loss. Where is the error?
Code: Select all
<?
include('connect.php');
$sql = mysql_query("CREATE TABLE users( user_id INT(11) NOT NULL AUTO_INCREMENT, username VARCHAR(255) NOT NULL FULL TEXT, password VARCHAR(32) DEFAULT 0 NOT NULL FULL TEXT, email VARCHAR(255) NOT NULL FULL TEXT, homepage VARCHAR(255) NOT NULL FULL TEXT, aim VARCHAR(100) NOT NULL FULL TEXT, date_format VARCHAR(50) NOT NULL FULL TEXT, date_join INT(11) DEFAULT 0 NOT NULL, post_last MEDINT(9) DEFAULT 0 NOT NULL, post_total MEDINT(9) DEFAULT 0 NOT NULL, PRIMARY KEY(user_id))");
echo 'Creating table: ''users''....';
?>