hey all,
I was just wondering how do I echo the reason why an INSERT INTO didn't work, at the moment I am just echoing that it didnt work, not WHY it didnt. I did a search on it, but dont really know how to explain it to get accurate results.
[SOLVED] - Show Errors
Moderator: General Moderators
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
[SOLVED] - Show Errors
Last edited by iknownothing on Sun Jan 28, 2007 11:36 am, edited 1 time in total.
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
Ok, by implementing this I have been given this error when trying to INSERT a row: "Column count doesn't match value count at row 1".
I've done some searching and it has all come up with some inconsistencies with the amount of values inserted, however, I has double checked mine and the Table holds 77 columns, and my Values count up to 77 also (with '' used for the auto incrementing ID).
Is there any other reason why this could be happening, maybe the fact that 77 columns is too many?
EDIT: SOLVED - Missed some commas.
I've done some searching and it has all come up with some inconsistencies with the amount of values inserted, however, I has double checked mine and the Table holds 77 columns, and my Values count up to 77 also (with '' used for the auto incrementing ID).
Is there any other reason why this could be happening, maybe the fact that 77 columns is too many?
EDIT: SOLVED - Missed some commas.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia