Mysql updating multiple rows
I've used to export the data out into excel and manually update the ADDRESS column and create individual update statements for each row.
The Maximum rows for a station is 27 minimum is 21 (multiples of 3).
Hi I'm trying to get this script to work, it almost works but doesn't update ALL the fields after you click submit.
Two fields don't display at all (the ones that don't update) .
Everything works fine now but "Record Number" doesn't show up on the 2nd page.
It's not super important that it does (would be nice) as it doesn't update but only helps me to use ctrl f to find things.
Within the script, PHP function My SQL_query() execute the SQL command.
The following My SQL statement will update the 'receive_qty' column of newpurchase table with a new value 25 if the value of purch_price is more than 50. I have 2 databases Oracle and My SQL and i need to update the same table on both database. using this query i can sort out the data in sequence select * from entity where name like 'A01%TYPE%E%' order by referencekey; NAME ADDRESS ..... php // connect to the database and select the correct database mysql_connect(localhost,username,password); mysql_select_db(db_name) or die("Unable to select database"); // find out how many records there are to update $size = count($_POST['Avalibity']); // start a loop in order to update each record $i = 0; while ($i < $size) mysql_close(); ?> <tr> <td colspan='4' align='center'> </td> </tr> </table> </td> </tr> </table></div></body></html> been one of my strong points.