Update Multiple Fields

[ririe44]

So, I've read up on a couple things on updating multiple fields, but I wanted to run this by you...

 

Can you do this so it's under one query?

 

$query = (UPDATE...) AND (UPDATE...) AND, etc? 

 

What would be the cleanest way to do this?  I have 36 fields being updated.  Thanks!

[premiso]

UPDATE set col1 = 'someval', col2 = 'someval' WHERE somecol = 'someval'

[ririe44]

I see how that'd work, but in my case every field will be different...

 

For example...

("UPDATE `$tbl_name` SET `amount` = '$budg_mustang' WHERE `sub_category` = 'Mustang'");

("UPDATE `$tbl_name` SET `amount` = '$budg_vulcan' WHERE `sub_category` = 'Vulcan'");

 

All 36 of them...

[ririe44]

Any thoughts anyone?

 

If I have to do individual queries for each... would I just do something similar?:

 

$query_mustang = ("UPDATE `$tbl_name` SET `amount` = '$budg_mustang' WHERE `sub_category` = 'Mustang'");

$query_vulcan = ("UPDATE `$tbl_name` SET `amount` = '$budg_vulcan' WHERE `sub_category` = 'Vulcan'");

if (mysql_query($query_mustang, $query_vulcan)) {
    echo "Your budget has been updated!  <br> Would you like to make another modification?  <a href='budg_retrieve.php'>Yes</a>";
}else {
    die(mysql_error());
}

[sasa]

UPDATE `$tbl_name` SET `amount` = CASE `sub_category`
WHEN 'Mustang' THEN '$budg_mustang'
WHEN 'Vulcan' THEN '$budg_vulcan'
...
ELSE `amount`
END