CpHpristian Posted May 15, 2009 Share Posted May 15, 2009 I'm using a SQL-Update QUERY.. $res = mysql_query("UPDATE user SET V_Name='$_POST[v_name]', N_Name='$_POST[n_name]', Passwort='$_POST[passwort]', Email='$_POST', Admin='$_POST[admin]' WHERE U_ID='$_GET[iD]'"); I guess with UPDATE every variable will be updated, even if it is the same value. Is there a way to tell how many values acutally got changed? Thank you so much! Link to comment https://forums.phpfreaks.com/topic/158319-affected-values/ Share on other sites More sharing options...
Porl123 Posted May 15, 2009 Share Posted May 15, 2009 <? mysql_query("UPDATE user SET V_Name='$_POST[v_name]', N_Name='$_POST[n_name]', Passwort='$_POST[passwort]', Email='$_POST', Admin='$_POST[admin]' WHERE U_ID='$_GET[iD]'"); printf(mysql_affected_rows()) ?> Link to comment https://forums.phpfreaks.com/topic/158319-affected-values/#findComment-835012 Share on other sites More sharing options...
.josh Posted May 15, 2009 Share Posted May 15, 2009 mysql_affected_rows only returns the number of rows affected, not what actual columns were affected. And even then, that number can be misleading, as it only counts a row as affected if there was an actual change. AFAIK there's no built-in function for that. You can first do a select and then use for instance array_diff if you want to find that out. Link to comment https://forums.phpfreaks.com/topic/158319-affected-values/#findComment-835015 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.