added ID column and now i can't insert

Fking

i'm using html form which via php adds entried in a table, everything was ok till i decided to add id column (id int unsigned not null auto_increment primary key FIRST)

now i get error ( MySQL insert query failed )

i was thinking that i do not need to change anything on the insert query because it sets the id automaticaly........but i guess that i'm wrong?

drawmack

try using mysql_errno and mysql_error to print the actual mysql error that is being generated.

Fking

ok, i got "Column count doesn't match value count at row 1"

so i guess this is cause of there were already entries before adding the id column
for luck they are only two and i decided to delete them

i executed
$query="DELETE FROM movies
WHERE title='title test'";

mysql_query($query) or die (mysql_error());
echo mysql_query($query);

and

$query="DELETE FROM movies
WHERE title='testing2'";

mysql_query($query) or die (mysql_error());
echo mysql_query($query);

for the second entry

i got "1" as output of echo mysql_query($query);

but still getting the same error when try to insert new entries

and infact i got 1 everytime i execute the code.....

drawmack

column count doesn't match value count means that in you insert you either have more values or more rows. You need to list the same number of rows and values. Your id field is an auto number so you should not be including this in field in the sql statement.

Fking

well i haven't touched anything on the insert query, i just added new column

drawmack

I can't offer any more assistance without seeing some code.

laserlight

What was the query you used to insert?

Fking

here is the query

$sqlquery = "INSERT INTO $table VALUES('$search_title[$i]','$search_titlebg[$i]','$search_description[$i]','$search_artists[$i]','$search_artists2[$i]','$search_artists3[$i]','$search_artists4[$i]', '$search_genre[$i]', '$search_genre2[$i]', '$search_genre3[$i]', '$search_subs[$i]', '$search_dir[$i]', '$search_url[$i]', '$search_url2[$i]', '$search_url3[$i]', '$search_pic[$i]','$search_size[$i]','$search_date[$i]')";

tsinka

Hi,

either specify the columns

INSERT INTO thetable (column1,column2,...) VALUES (value1,value2,....)
or add a null in the query at the position that matches the position of the auto_increment field.

Thomas

Fking

hehe, works
thanks people, you helped me a lot