Posted on 2011-03-01
I have a script that updates a database. It updates about 100 field from information that is being parsed from a feed. What type of query code would I need to write so that the UPDATE that ran would report to me the fields that were updated?
I want it to echo each field_id that was actually affected/updated:
$q = "UPDATE exp_weblog_data SET field_id_29='$field_id_29', field_id_30='$field_id_30', field_id_31='$field_id_31' WHERE field_id_215='$field_id_215'";
if ($return = mysql_query($q, $yourconnection))