necrotic — Wed, 18 Sep 2002 19:09:19 +0000

Thanks guys! It works like a dream now! I thought it would be something simple like that.

mairving — Wed, 18 Sep 2002 13:44:55 +0000

You can use the id field if you want. Before I knew better, I used to do it as insert into tablename (id) values ('NULL'). This forces the auto-increment to happen. It is much cleaner and easier to leave it off though. Any time I run into a problem like this, I usually try echoing the statement to the screen to make sure that I am picking up the right data and then try inserting the same SQL statement without using the script, either through the command line or phpmyadmin. This tends to help solve all of those mysteries.

Peter J. Boettcher — Wed, 18 Sep 2002 13:24:56 +0000

Mark is right, you don't need to include the id field since it is auto increment. nike_guy_man is also correct, while it will work without quotes around your variables you really should include them because if your variable has a comma or a double quote in it then it will break your query.

nike_guy_man — Wed, 18 Sep 2002 10:45:57 +0000

Don't you also need quotes around the values?? I've ran into that problem a few times...
Are you getting any errors?

Mark Hensler — Wed, 18 Sep 2002 10:36:17 +0000

omit the `id` field from your query