The best way to compare a database row with a submitted form data

woorhoona

New Member
I have a table with 8 fields and a corresponding form. When the form is submitted, I have the id of the record. What is the best way to check if data in any one of the fields has changed for that row? Should use the SQL route\[code\]WHERE field1=$field1 AND field2=$field2 ..... AND ID=$ID\[/code\]or pull the row and compare each field with a loop? Any other ways of achieving this?Thanks!
 
Back
Top