•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 363,395 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,927 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 495 | Replies: 19 | Solved
![]() |
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 2,884
Reputation:
Rep Power: 7
Solved Threads: 208
No. If `id` is an autoincrement field, you don't have to do anything with it..
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
Getting closer !!
Column count doesn't match value count at row 1
php Syntax (Toggle Plain Text)
$sql = "INSERT INTO trucks (`relpath-box1`, `relpath-box2`, `relpath-box3`, `relpath-primary`, `relpath-gallery1`, `relpath-gallery2`, `relpath-gallery3`, `year`, `make`, `model`, `miles`, `comment`, `option1`, `option2`, `option3`, `option4`, `option5`, `option6`, `option7`, `option8`) VALUES ('$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]', '$data[5]', '$data[6]', '$data[7]', '$year', '$make', '$model', '$miles', '$comment', '$option1', '$option2', '$option3', '$option4', '$option5', '$option6', '$option7', '$option8')";
Last edited by peter_budo : May 14th, 2008 at 1:28 pm. Reason: Keep It Organized - please use [code] tags
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 2,884
Reputation:
Rep Power: 7
Solved Threads: 208
I have already mentioned that problem.. the column count is 20 and the values you are trying to insert is 21.
I hope that fixes it
I hope that fixes it
Last edited by nav33n : May 14th, 2008 at 11:43 am.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 2,884
Reputation:
Rep Power: 7
Solved Threads: 208
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Other Threads in the MySQL Forum
- Previous Thread: Please help populate my first functional database.
- Next Thread: netbeans6.0 & MySQL database



Linear Mode