[MySQL] Update Multiple Rows At Once

[Adrian Schneider]

PHP Code:

$result = mysql_query("UPDATE tablename SET field='$field'") 

or die(mysql_error()); 


Wouldn't that update all the rows? There is no WHERE clause.

Do you want a javascript method where it updates the form elements? or a PHP method which updates all of the records in the database?