CREATE TABLE issues

[Nim199]

Hi, I am trying to Create the tables for a Forum.Here is my code, can you please tell me what is wrong with it.

<?php$con = mysql_connect("######","######","######");mysql_select_db("######",$con);$CMembers = "CREATE TABLE members(UserID integer(6),UserName varchar(50),UserPassword varchar(20),Posts integer(6),BirthDate date(yyyymmdd),Statement varchar(200))";mysql_query($CMembers,$con);mysql_close($con);?>

$con is correct, and I have create the database, it exist, and the true name is correct.Note: SHARP (#) signs act as wild card(s). I have put them in for security. The number of '#' does not correspond with the number of charactors.

[murfitUK]

I don't think INTEGER is a valid type. You can use things like INT, TINYINT, SMALLINT, MEDIUMINT and BIGINT, or NUMBER(3) for 3-digit numbers, FLOAT, DOUBLE and DECIMAL etc.

[Nim199]

I don't think so. I have used 'Integer' before without any problems, but I will try with INT when I can next.

[justsomeguy]

If it doesn't work then you need to print the error message from MySQL to figure out what the problem is, that's a lot easier then guessing. The mysql_error function will return the last error message.

[Synook]

On MySQL the engine does not accept the yyyymmdd argument for the date field type - there is only one type of "date" in MySQL, in the format YYY-MM-DD. That cannot be changed.There is a list of MySQL field types here - http://www.xnote.com/howto/mysql_field_types.htmlINTEGER is a valid alias of INT.

[Nim199]

No error meassag returned. Just a blank screen.

[justsomeguy]

If there's no error message from mysql_error then the query worked. Otherwise there would be an error.

[Synook]

You have to type

echo mysql_error();