Updating mysql row

my table properties `STY_REPORT_200501` ( `std_nis` int(10) NOT NULL default '0', `std_class` varchar(10) default NULL, `std_item` int(2) default NULL, `std_value` float default NULL, `std_letter` char(2) default NULL, `std_entusr` varchar(10) NOT NULL default '', KEY `std_class` (`std_class`), KEY `std_item` (`std_item`), KEY `std_value` (`std_value`), KEY `std_letter` (`std_letter`), KEY `std_entusr` (`std_entusr`) ) TYPE=My ISAM; I'm doing this query SELECT * FROM `STY_REPORT_200501` WHERE 1 LIMIT 0 , 30 when I how do I make multi row update based on my fetch result ?

On EVERY row that is printed out there are two columns that the user can interact with: a dropdown box, and a text input.

They can change the value of the dropdown box and enter text in the text input.

-php-mysql except I changed my code to have one button at the top instead of one at the end of every row, to make things easier for the users.

I take values from a MYSQL table and print them into an HTML table using PHP, in a while loop.

My SQL UPDATE multiple columns My SQL UPDATE command can be used to update multiple columns by specifying a comma separated list of column_name = new_value.

Where column_name is the name of the column to be updated and new_value is the new value with which the column will be updated.

In particular, the field "num_points" is a little unusual.

I made it up so I could show an int data type in this table, and I was thinking of those websites where points are awarded for giving correct answers.

The following My SQL statement will update pub_lang column with NULL if purch_price is more than 50.

Tags: , ,