check boxes to radio buttons

[snappy]

Hi all

I have the following code

<?php
$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name=""; // Database name 
$tbl_name=""; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table>
<tr>
<td><form name="form1" method="post" action="">
<table>

<tr>
<td>#</td>
<td>Id</td>
<td>Name</td>
<td>Lastname</td>
<td>Email</td>
<td>Value</td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td>
<input name="checkbox" type="checkbox" value="<? echo $rows['id']; ?>">
</td>

<td><? echo $rows['id']; ?></td>
<td><? echo $rows['name']; ?></td>
<td><? echo $rows['lastname']; ?></td>
<td><? echo $rows['email']; ?></td>
<td><? echo $rows['value']; ?></td>
</tr>
<?php
}
?>
<tr>
<td><input name="update" type="submit" id="update" value="Update"></td>
</tr>
<?
// Check if delete button active, start this 
if($update){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "UPDATE $tbl_name SET value = '0' WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php 
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=test1.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

What this does is that it gives you a row from the table with a checkbox, if the checkbox is selected and the submit is selected the form is updated.

What I would like to know is how would I change the check boxes to 2 individual radiobuttons. Then when I select the one it updates the table a value (say "1") and when the other is selected it updates the table with another value (say "2")

Thank you very much

[hennety]

Probably a quick and simple way of doing this would be to change your checkbox form element:
<input name="checkbox" type="checkbox" value="<? echo $rows['id']; ?>">

to a hidden element:

<input name="some_id" type="hidden" value="<? echo $rows['id']; ?>">

and insert 2 radio button elements instead:

<input name="status" type="radio" value="1">
<input name="status" type="radio" value="2">

You should be able to pickup the values with a simple if(){}else{} to determine which radio button has been checked.

And just to make things even more fun, pull back the status value (or whatever your column name is) in your query so that the correct radio button is checked when you arrive at the page:

if($row['status'] == 1){
<input name="status" type="radio" value="1" checked=checked>
<input name="status" type="radio" value="2">
}
elseif($row['status'] == 2){
<input name="status" type="radio" value="1">
<input name="status" type="radio" value="2" checked=checked>
}

Hope that helps.

[snappy]

Thanks for the comment

I think the radio buttons work with a foreach($radio as $val){}

If I change the checkbox as you suggested to a hidden field, i can't seem to get the $del_id to work, any suggestions ?

[hennety]

If register_globals is set to off (which it should be) in the php.ini file, try referencing it with:
$del_id = $_POST['some_id'];
and see how that goes.