what is wrong with my insert query?

[seanpaulcail]

I have a table with the following columns

page_number
page_name
image1
image2
image3
image4
image5
image6
image7
image8

when I run the following insert command I get an error

update small_images
set  image1='attia01_sm.jpg',
set image2='attia02_sm.jpg',
set image3='attia03_sm.jpg',
set image4='attia04_sm.jpg',
set image5='attia05_sm.jpg',
set image6='attia06_sm.jpg',
set image7=null,
set image8=null,
where page_number= 3;

what is wrong with my insert query?

thanks

[LordShryku]

set image8=null,

Remove the comma.

And if you get an error, tell us what is it. Would help us narrow down the problem faster.

[seanpaulcail]

I removed the comma

here's the error

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET image2 =  'attia02_sm.jpg',

thanks

[LordShryku]

Okay, now remove the duplicate "set"s.

UPDATE small_images
   SET image1='attia01_sm.jpg',
       image2='attia02_sm.jpg',
       image3='attia03_sm.jpg',
       image4='attia04_sm.jpg',
       image5='attia05_sm.jpg',
       image6='attia06_sm.jpg',
       image7=NULL,
       image8=NULL
 WHERE page_number= 3;

[seanpaulcail]

thanks LordSchryku