Column count doesn’t match value count at row 1 Error

@nzzSep 04.2012

Hi,

i am trying to store some values into a database, but upon trying to add i am getting a “Column count doesn’t match value count at row 1”

i believe i am passing something incorrectly but was hoping someone could point me in the right direction

i have included my code [URL=”<script src=”http://pastebin.com/embed_js.php?i=JTrXc23V”></script>”]here[/URL]

many thanks

to post a comment

PHP

@holyhttpSep 07.2012 — #You certainly do not have the correct number of field data in the first row of your query.

It maybe because you have a misplaced comma or quote somewhere.

If you need an extra pair of eyes then paste your query for us to see.

Please double check, and you'll discover you were missing something.

@nzzauthorSep 07.2012 — #thanks for the reply

my code is here > http://pastebin.com/JTrXc23V

@holyhttpSep 07.2012 — #You did not indicate how many fields your database table has. So there is no way to make the column count comparison just by looking at your code.

There is an excessive use of single quotes in your query that forces you to add escape slashes and makes your code hard to read.

You have a syntax error at time () . ('

How about for instance:

$sql="INSERT INTO $dblist VALUES(

'0',

'".$_POST['userid']."',

'".$_POST['location']."',

'".$row['type']."',

'".time ()."',

'".time ()."',

'".$expire."',

'".$row['expire']."'

'0',

'0',

'".$_POST['hide']."',

'".$_POST['featured']."',

'".$_POST['status']."'",

'1',

'".$_POST['stock']."',

'".$_POST['vin']."',

'".$_POST['model_year']."',

'".$_POST['make']."',

'".$_POST['model']."',

'".$_POST['cond']."',

'".$_POST['category']."',

'".$_POST['category2']."',

'".$_POST['mileage']."',

'".$_POST['mileage_alt']."',

'".$_POST['price']."',

'".$_POST['sale']."',

'".$_POST['price_alt']."',

'".$_POST['exterior']."',

'".$_POST['interior']."',

'".$_POST['doors']."',

'".$_POST['fuel']."',

'".$_POST['drive']."',

'".$_POST['engine']."',

'".$_POST['trans']."',

'".$_POST['top_speed']."',

'".$_POST['horsepower']."',

'".$_POST['torque']."',

'".$_POST['towing']."',

'".$_POST['features']."',

'".$_POST['description']."',

'".$_POST['tagline']."',

'".$_POST['link_url']."',

'".$_POST['link_text']."',

'".$_POST['ebay_url']."')";

if (!(mysql_query($sql, $link))){ exit (mysql_error ()); }

You also need to use the addslashes() function to all submitted data to prevent SQL injection (e.g addslashes($_POST['engine']) )

By using the $sql variable is provide and comparing the number of fields with the column count of your table you should be able to easily spot the errors.

Always write your code with simplicity and readability in mind.

@nzzauthorSep 10.2012 — #Thanks for replying

i have 49 fields in my database (listed below)

id

userid

location

user_type

added

updated

expire

user_expire

viewed

images

hide

featured

status

pending

stock

vin

model_year

make

model

cond

category

category2

mileage

mileage_alt

price

sale

price_alt

mot

mot_expire

reg_plate

reg_docs

owners

exterior

interior

doors

fuel

drive

engine

trans

top_speed

horsepower

torque

towing

features

description

tagline

link_url

link_text

ebay_url

i have since removed the incorrect syntax

so the code now reads

'' . time () . '',

unfortunately this gives me a blank white page

if i get this fixed i will then make a start at improving my code

Column count doesn’t match value count at row 1 Error

4 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Column count doesn’t match value count at row 1 Error

4 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

4 Comments(s) _↴

Also in #PHP _↴