Print out your data onto a master page, with checkboxes.  The checkboxes
should be an array, with the ID (or some other unique identifier) of each
row.  The array would look something like:

$approve['1'] => 'Y';
$approve['2'] => 'Y';
$approve['3'] => 'Y';
$approve['10'] => 'Y';

The array will only contain rows which were checked.

Then on the next page, you loop through the array with a foreach statement,
updating the table to suit:

foreach($approve as $k => $v)
    $sql = "UPDATE .... WHERE id='{$k}'";
    $result = mysql_query($sql);

Hope this is enough to get you started.

Justin French

on 17/08/02 1:37 PM, Lists ([EMAIL PROTECTED]) wrote:

> Hi everyone,
> I'm a newbie.  I've been searching google and php.net trying to find
> information on how to set up a Master Page to do multiple records updating,
> but have found very little.  I have a table with 10 rows of data from MySQL
> and I'd like the user to check the "Approve" checkbox and for as many as he
> wants to approve and then click "Submit".
> If someone could point me in the right direction, I'd greatly appreciate it!
> Thanks,  Doug

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to