RE: [PHP] How do you set up table columns for numerals?

I looked at your page. First off, you should add a primary key column that has no information in it. Just make this a number(4) called state_id. Then you will be able to specify that it's auto_increment. The problem you had is that you tried to make a varchar column auto_increment which makes no sense. Auto_increment will start at 1 and each time you insert a new row will assign a unique key = max(state_id)+1 Also any number columns should be number types. You can apply formatting (commas separating 100's) when you select the data or present it with php. As for your other issues, I can't see what the error message was, but when you are using number types like smallint, you shouldn't specify lengths.. these are implicit in the type. A smallint for example is 2 bytes. This means that you have 64k of possible integers that can be stored in there. What you do want to make sure is that it's unsigned. -----Original Message----- From: Freedomware [mailto:david_blomstrom@yahoo.com] Sent: Friday, January 23, 2004 6:41 PM To: php-general@lists.php.net Subject: [PHP] How do you set up table columns for numerals? I'm having some roblems creating a table with phpMyAdmin. I think they're pretty minor problems, mostly relating to numerals. Would someone be willing to look at my notes at http://geowebworks.geobop.org/mysql/3.php - especially the last picture - and suggest what I need to do to fix it? It's also possible the instructions I'm following are flawed, though they look pretty sensible. Here's the last error message I got: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(20), Area VARCHAR(6), Area SMALLINT(8), HighestAltitude -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php