Syntax for multiple update.

[omoutop]

hi to all!

how can i get all this in one query?(silly question I think but dint know how....)

$query2 = "update Reviews set Title='$Title' where ID='$ID'";
$result2 = mysql_query($query2);
$query3 = "update Reviews set Description='$Description' where ID='$ID'";
$result3 = mysql_query($query3);
query4 = "update Reviews set name='$name' where ID='$ID'";
$result4 = mysql_query($query4);
...........more continued....

any ideas?

[omoutop]

OK, no worries, problem solved!

[mcibor]

Yep, you can:

$query2 = "UPDATE Reviews SET Title='$Title',
Description='$Description',
name='$name' WHERE ID='$ID'
LIMIT 1";//to update just one row.
$result2 = mysql_query($query2);

Best regards

Glad you sorted it out

Michal Cibor

[omoutop]

that's right my friend...i just had to update a record from the phpmyadmin and view the code in php ;)...so simple yet so tough to think sometimes...