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! Quote 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()) ?> Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/158319-affected-values/#findComment-835015 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.