For Help

[tobeyt23]

I have a list of messages and would like to have a radio used to select the one to make active, then when the user submits the db is updated to reflect the radio selected. Currently this is not happening any suggestions on how to fix this:

 

<?php
// update status settings
if ($submit == "Update Status") {
if (isset($emergencyid)) {
	for ($i = 0; $i < count($emergencyid); $i++) {
		$query = "UPDATE $tableMessage SET status=" . $status[$i]) . " WHERE emergencyid=" . $emergencyid[$i];
		$res = mysql_query($query);
		if (mysql_error()) {
			doStop("Message Status Failed", $query);
		}
	}
}
}
?>
<tr bgcolor="#1b3d6a">
<td valign="top" align="center" bgcolor="#ffffff"><input type="hidden" name="emergencyid[]" value="3"><label for="status[]"></label><input type="radio" name="status[]" id="status[]" value="1" checked class="admin"></td>
<td valign="top" bgcolor="#ffffff">Test</td>
<td valign="top" bgcolor="#ffffff">09-04-2007</td>
</tr>
<tr bgcolor="#1b3d6a">
<td valign="top" align="center" bgcolor="#f5f5f5"><input type="hidden" name="emergencyid[]" value="1"><label for="status[]"></label><input type="radio" name="status[]" id="status[]" value="1" class="admin"></td>
<td valign="top" bgcolor="#f5f5f5">A Breaking News Message can go here, or not, at the admin's preference.</td>
<td valign="top" bgcolor="#f5f5f5">08-14-2007</td>


</tr>

[darkfreaks]

Try

 

<?php
die("Message Status Failed". mysql_error($query)) ;?>

 

[lemmin]

Currently this is not happening...

What is happening?

 

Do you have multiple sets of radio buttons; Can the use ever click more than one radio button to submit? I'm just curious because you don't show that they can and if that is the case, there is no reason to use an array.

[tobeyt23]

No they can only select one at a time and i wanted so if they select a different one then currently selected it updates the rest in the db to not active.

[lemmin]

If they can only select one, you don't need to use an array for the names in your form. It would be easier to troubleshoot if I knew what was happening in place of what you want to happen.

[tobeyt23]

What is happening is if i select the last on the first is updated as active not the last one if i select the first it updates correctly.

[lemmin]

I really don't understand that, but it might be because you are using the arrays for no reason. Try it with normal variable names.