Updating more than one record

Anon

I have a set of check boxes that is fetched from a Mysql DB (a list of records) with check boxes next to them indicating the records available for that user. Giving them the option to chosse the record they would like to update to a preset value (if check make record as yes)

if they check more then one record can I update the table with one submit

Thank In Advance
Richie TM

[deleted]

You can give the all the checkboxes the same name, like 'records[]' (including the brackets), and for a value you can use the record's ID from the database (assuming you have an ID column)

After posting, the checkbox data will be available in the POST or GET data as an array called 'records'.

You can then use that data to build your query or queries.

Anon

So I should do some thing like this for the form

$result = mysql_query("SELECT * FROM table WHERE user_id = $user_id
while ($row = mysql_fetch_array($result)) {
print "<input type=\"checkbox\" name=\"record[user_name]\" value=\"yes\"> - $order";
}
?>

But what about the query will if loop though the query to input the data to all records

Thanks again
Richie TM

vincent wrote:

You can give the all the checkboxes the same name, like 'records[]' (including the brackets), and for a value you can use the record's ID from the database (assuming you have an ID column)

After posting, the checkbox data will be available in the POST or GET data as an array called 'records'.

You can then use that data to build your query or queries.

egervari

why do you have database access, logic and html in the same piece of code? just a question...

Anon

I was try to find out a question on updating more then one record in one submittion from a HTML form

The process requires a user to view all order under his account and to be able to check off all order he was to process

in this case the select statement is to fetch all of the user orders and list them in a html form to be selected for processing

my question is how can I update the record he has chossen for processing

Richie TM

egervari

you have to go

if( $value == 'yes' ) echo 'checked';

because when you go <input name="blah" value="yes" checked>, that will make it checked. <input name="blah" value="yes"> is unchecked.

What I meant by my last comment was not why in the logic, but you should seperate it more to make it clearer 😛

[deleted]

Not quite.

What you want to end up with is a list of those records that the user has selected.
SO just make the name 'record[]'
and use something like $row['recordid'] for the value.

Then when you submit, all the selected recordid's will be put into the array.