error inserting data into table

[chazzy69]

Ok heres the code im using to insert data into a table-

$import="INSERT into default_en_listingsdbelements(listingsdbelements_id,listingsdbelements_field_name,listingsdbelements_field_value,listingsdb_id,userdb_id) values('$data[0]','$data[1]','$data[2]'','$data[3]'','$data[4]')";

now the error im getting is "Column count doesn't match value count at row 1",

just wondering what exactly is this error referring to and how i can fix it?

Any help greatly appreciated, cheers

[mwasif]

There are double single quotes after $data[2] and $data[3].
[code=php]$import="INSERT into default_en_list ingsdbelements( listingsdbeleme nts_id,listings dbelements_fiel d_name,listings dbelements_fiel d_value,listing sdb_id,userdb_i d) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')"; [/code]

[chazzy69]

oh lol completely blind, thanks :)