[thelist] Re: Trying to create table in MySQL DB with phpmyadmin

[Matthias Willerich]

Chris,

You shouldn't use BIGINT for the id, at least not if you're using
mysql_insert_id() in the php, as this might return the wrong number.
http://uk.php.net/mysql_insert_id

INT( 255 ) would probably be the next biggest candidate. When you get errors
while creating a table, it's usually down to using a keyword(which you can
escape) or to not putting in a value for the size of the field. Not all
fields want one, but hey, most do, and it makes you think about the needed
dimensions as well.

Matthias