Re: [PHP] auto-increment not working?? MySQL

2004-07-12 Thread Curt Zirzow
* Thus wrote Jay Blanchard: > [snip] > i've got a strange problem with a MySQL table. although my 'id' column > is set to 'auto_increment', each new record i insert has the value 1. > (instead of 1, 2, 3, etc.) > > i checked my sql statement and i'm not assigning the id value by > mistake. here is

Re: [PHP] auto-increment not working?? MySQL

2004-07-12 Thread barophobia
On Mon, 12 Jul 2004 15:36:20 -0500, Jay Blanchard <[EMAIL PROTECTED]> wrote: > The guys on the MySQL list do. Have you read this--> > http://dev.mysql.com/doc/mysql/en/example-AUTO_INCREMENT.html not for this issue no. the problem for those that read this later is not that i am using multiple pr

Re: [PHP] auto-increment not working?? MySQL

2004-07-12 Thread Justin Patrin
Your primary key should be only (`id`). On Mon, 12 Jul 2004 13:04:19 -0700, barophobia <[EMAIL PROTECTED]> wrote: > hello. > > i've got a strange problem with a MySQL table. although my 'id' column > is set to 'auto_increment', each new record i insert has the value 1. > (instead of 1, 2, 3, etc.

RE: [PHP] auto-increment not working?? MySQL

2004-07-12 Thread Jay Blanchard
[snip] i've got a strange problem with a MySQL table. although my 'id' column is set to 'auto_increment', each new record i insert has the value 1. (instead of 1, 2, 3, etc.) i checked my sql statement and i'm not assigning the id value by mistake. here is my create statement (showing only a few c