Multiple update in single query.

[eluser]Arun Joshi[/eluser]
I have to update multiple rows of my photos table. I have a dynamic built query like this.

Code:

$query    =    "
UPDATE photos SET description='des one' WHERE photo_id='4';
UPDATE photos SET description='des two'' WHERE photo_id='5';
UPDATE photos SET description='des 3' WHERE photo_id='6';
";

But when I tried this with $this->db->query($query); it shows error. When I copied this query to phpmyadmin, it executed successfully.

Any reason there for this?

Thanks
Arun