Strange Table Problem

Anon

This is wierd and i can't figure it out. i have a table with 19 fields, the first field is my id field and it is set as primary key, auto increment.

I begin to add my information into the table using php and a form. I click submit and the information is added, no problem. i continue to add records until i get to record 11, and then my die statement pops up, "Couldn't execute query". I don't get it!, It took the first 10 records just fine, no prob. Does anyone know why i can't get more the 10 records onto my table. I will post my code, if anyone wants to see it. Thanks for any help.

Anon

Hmmm
I don't think there is anything wrong with your code if it is letting you insert the first 10 records fine. You might want to check your database you might have a size restriction on how big your table can get. You said your table contained 19 fields do any of the fields contain a picture or something that might be a large? If so try taking that field out and see if you can insert more records in to it. I think it’s more of a size issue then a php coding issue.

[deleted]

Another example of bad error-checking.
read this:
http://www.hvt-automation.nl/yapf/index.php#4

Anon

Actually, i had all the error checking, and code written perfect. Thanks varun, you were close when you mentioned size, so i went back into mysql to recheck everything and noticed I specified a field length for my primary key auto increment field and that is what was causing the problem. Thanks!

Anon

I was having the same problem last week hehe and i know how aggravating php can be. Your welcome Sheldon and good luck.

🙂

[deleted]

If you had proper error checking you'd get a mesage from your database saying that that was the problem. sigh.