Re: [PHP-DB] Adding Record to database

2003-02-02 Thread Matt
Thanks a lot guys. I thought I had something auto incremented, but I didn't. That was the problem. Thanks for your help. Matt "Miles Thompson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Matt, > > Check a couple of things: > > 1. Do you have a primary ke

Re: [PHP-DB] Adding Record to database

2003-02-02 Thread Miles Thompson
Matt, Check a couple of things: 1. Do you have a primary key with unique id? You could be getting a key violation. 2. Echo $query and confirm that it is as you expect. 3. Add code to trap for, or at least display any generated error. 4. Are you able to test this INSERT at the MySQL console? If

[PHP-DB] Adding Record to database

2003-02-02 Thread Matt
Hi. I am having a problem with adding a record into a table of a database. I have attached the code I am using to accomplish this. It works if the table is empty, but if there is already a record in the table, it won't add anything. Could anyone help me out with this? Here is the code I am usin