Hi, I was wondering if I could get some help. I'm basically writing a script that allows an administrator to give members of a website access to certain areas. The script is a basic Form with radio buttons giving the option to Allow or Deny access.

PHP Code:

<form method="POST" action="update.php">

<?

include "config.inc.php";

mysql_connect($domain,$MySQLusername,$MySQLpassword);
@mysql_select_db($database) or die( "Unable to select database");
$sql = mysql_query("SELECT * FROM users WHERE memberof = 'The Buddhist Fist' AND auth = 'FALSE'");
$fetch = mysql_fetch_array($sql);
$totalmembers = mysql_num_rows($sql);


$i=0;
while ($i < $totalmembers) {


$approval_id=mysql_result($sql,$i,"id");
$approval_member=mysql_result($sql,$i,"gcharacter");


echo "
$approval_member
<br>Approve<label><input name=\"ID['$approval_id']\" type=\"radio\" value=\"Approve\"></label>
<br>Deny<label><input name=\"ID['$approval_id']\" type=\"radio\" value=\"Deny\"></label>
<br>Pend<label><input name=\"ID['$approval_id']\" type=\"radio\" value=\"Pend\" checked></label>
<br>
<br>";

$i++;
}

?>

<input type="submit" value="Submit">
</form>

The problem is, I have no idea how to update multiple records like this!
I pretty much want my Update script to change the Auth record in MySQL to TRUE, FALSE or PEND (depending on which button was selected).

Can anyone give me an example of how my Update.php should look?

Any help would be much appreciated! Thanks

Yeah, i don't understand why you've gotten no reply on this.

Radio buttons work just like the text field will in PHP, so there is nothing very complicated about it. PHP will place whatever the radio name and value is into the $_POST array, once the form has been submitted, ignoring the values not selected. So in your case, the Radio is called "ID103883" or whatever number goes after the ID bit, and lets say the user selected "true", to call this in PHP, we simply use $_POST['ID103883']

This variable calls, from the $_POST array (because you've used the POST method on your form, not GET) whatever value is associated with the key "ID103883".

I take it you know the SQL code for this? You'll also need to include the member ID in a hidden input somewhere in the HTML, otherwise you won't be able to identify where to update the database, and mySQL will cry.

Thank you so much for your help.
As soon as you said about the hidden field I instantly knew how I was going to do it.

I made a some minor changes to my form

PHP Code:

<input type=\"hidden\" name=\"id[$approval_id]\" value=\"$approval_id\">
<br>Approve<label><input name=\"OptionID[$approval_id]\" type=\"radio\" value=\"Approve\"></label> 
<br>Deny<label><input name=\"OptionID[$approval_id]\" type=\"radio\" value=\"Deny\"></label> 
<br>Pend<label><input name=\"OptionID[$approval_id]\" type=\"radio\" value=\"Pend\" checked></label> 


Then I made the following Update script

PHP Code:

<?

include "config.inc.php";

$OptionID=$_POST['OptionID'];
$id=$_POST['id'];


// Connect to MySQL
mysql_connect($domain,$MySQLusername,$MySQLpassword);
@mysql_select_db($database) or die( "Unable to select database");


/*Now Loop through entries and update checked ones*/

foreach ( $id as $memberid ) {

$Grant=$OptionID[$memberid];

echo "$memberid -----  $Grant <br>";

$query="UPDATE users SET auth='$Grant' WHERE id='$memberid'";
mysql_query($query);


}

mysql_close();

?>

And it works a treat!
I decided to get rid of the idea of having TRUE, FALSE & PEND in my table. So now it just updates with Approve, Deny and Pend.

Thanks a lot for your help!

My god, the one time my advise work first time!

It's nice to see someone actually telling us if it worked and saying thanks!