MySQL Table Stucture!

[DJTim666]

mysql_query("INSERT INTO `users` ( `id` , `username` , `password` , `email` , `rp` , `gender` , `birthday` , `date_registered` )
VALUES (
NULL , '$user', '$pass', '$email', '2500', '$gender', '$birthday', '$date'
);");

 

Can anyone help me make a table structure for that information please

[DJTim666]

bump

[tippy_102]

<?php
mysql_query("CREATE TABLE users(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
username VARCHAR(30), 
password VARCHAR(30), 
email VARCHAR(30), 
rp VARCHAR(30), 
gender VARCHAR(7), 
birthday DATETIME, 
)")
or die(mysql_error());  

echo "Table Created!";
?>

 

The lengths (the numbers in the brackets) will have to be changed to suit your needs and I don't know what type of data you are using for gender or date, but this will give you an idea of how to do it. 

[DJTim666]

Thanks, I am using this format for the date; $date = date('l, F d, Y');

[TRI0N]

Is date in the database set for a Date Format?  If so the date format for MySQL is Y-m-d (2007-05-19).  Inserting anything that is not in that format will be messed up. Now if your Date row is varchar then you shouldn't have a problem using the format you have now. But if it is set for DATE you will have problems.