In the meantime, I have a question:
I need to update multple rows in a MySQL database from a single form submit. Each row has 6 fields. The form is dumping the fields to a validation/insertion script. I am getting the variables there with:
Code: Select all
$snapshot_id = $_POSTї'snapshot_id'];
$date_id = $_POSTї'date_id'];
$security_id = $_POSTї'security_id'];
$no_units = $_POSTї'no_units'];
$unit_value = $_POSTї'unit_value'];
$owner = $_POSTї'owner'];Also, could/should I be doing something on the form page to better order the POST (se below) am I delimiting the rows wrongly?
It appears that only the first row is being passed if I echo my variables on the submit page.
The form page is submitting the values thusly - in multiple rows where $security_id delimits the row. Each row is:
Code: Select all
<input type='Hidden' name='date_id' value='$date_id'>
<input type='Hidden' name='owner' value='1'>
<input type='Hidden' name='snapshot_id' value='null'>
<input type='Hidden' name='security_id' value='$security_id'>
<input type='Text' name='unit_value'>
<input type='Text' name='no_units'>Thanks,
Gord