09-22-2010, 02:18 AM
[eluser]Arun Joshi[/eluser]
I have to update multiple rows of my photos table. I have a dynamic built query like this.
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
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';
";
Any reason there for this?
Thanks
Arun