For example, let us say that we have a table called cars and that we want to update the row with the ID “90” (it’s Primary Key).

I am trying to understand how to UPDATE multiple rows with different values and I just don't get it.It says success because it has no other option as long as the DB connect works.Try printing out the post values and make sure you're actually getting values where you should be and for the record that is seriously insecure code.$query="UPDATE client_info SET first='$ud_first', last='$ud_last', phone='$ud_phone', mob='$ud_mob', fax='$ud_fax', email='$ud_email', web='$ud_web', com='$ud_com', add='$ud_add', city='$ud_city', state='$ud_state', zip='$ud_zip', zone='$ud_zone', office='$ud_office', office_num='$ud_office_num', ext_mob='$ud_ext_mob', ext_phone='$ud_ext_phone', ext_office='$ud_ext_office', password='$ud_password' WHERE id=$ud_id;"; mysql_query($query) or die(mysql_error()); something out of the range of this question byt why assign each of the result values separately?The solution is everywhere but to me it looks difficult to understand.Hi, I have My SQL version 3.22.23b installed in rpm format ! rpm -Uvh My SQL*rpm -e My SQL* ; rpm -ivh My SQL*rpm -e My SQL* ; [install source tgz version]??