MySQL and Tables

chalbing

K, i finally got to start playing around with MySQL and now i am not able to create tables. is there something special that i need to know about? this is the system the line that i am using. and my site loads and displays "did not create the tables".
is there another command that i can try to use to get this to work?

if(!(mysql_query("CREATE TABLE $user_tablename ($user_table_def)"))) die (" did not create the tables");

[deleted]

Show use what goes into "$user_tablename" and "$user_table_def".

shivers

assuming you did all the necessary connection bits beforehand, use

mysql_error($linkid)

to tell you why it failed.

its also often useful to echo the query to the page so you can verify that it's actually valid SQL

chalbing

k, below it he whole script. hope you guys can help me.

<?php
mysql_connect("localhost", "login", "password");
$dbname = "oxgames";
$user_tablename = 'news';
$user_table_def = "id MEDIUMINT(10) DEFAULT'0' NOT NULL AUTO_INCREMENT,";
$user_table_def = "postid VARCHAR(8) BINARY NOT NULL,";
$user_table_def = "submitedby VARCHAR(30) BINARY NOT NULL,";
$user_table_def = "tile VARCHAR(50) NOT NULL,";
$user_table_def = "article LONGTEXT NOT NULL,";
if(!(mysql_select_db($dbname))) die(" could not select database");
if(!(mysql_query("CREATE TABLE $user_tablename ($user_table_def)"))) die (" did not create the tables");
echo " we made all the tables.<BR>";
?>