select only 1 record .!

[npereira]

How can I have my PHP script make sure that there is only 1 checkbox seleted?

Regards,

Nelson

[Aeiri]

To do that you would need Javascript, but if you are only needing one checkbox selected, why are you using checkboxes? Why not use Radio Buttons? They are the same thing only circles, and they can only have one selected at a time...

[npereira]

In my script, even if I change to radio buttons, I can still select more than 1. I don't know why though!.

[Smifffy]

are they within the same <form> tags????
that could be the prob - not sure thou

[npereira]

Smiffy,

I don't understand your question!

Here is a look at the script and where the <input type> is;

///////////////////////////////////////////////////////////////////////
default:
print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"75%\"><tr>");
print("<form action = \"$PHP_SELF\" method=\"post\">");
print("<td align=\"center\" colspan=\"4\">");
print("<input type=\"submit\" name=\"MessageType\" value=\"Modifier\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"MessageType\" value=\"Ajouter\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"MessageType\" value=\"Effacer\">&nbsp;&nbsp;&nbsp;");
print("</td></tr>");
$count        =    1;
$colsprinted    =    0;
$totalcols    =    3;
$totalitems    =    0;
$query         =    "select * from membres order by nom";
$mysql_result    =    mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
if($colsprinted == $totalcols)
{
print("</tr><tr>");
$colsprinted    =    0;
}
printf("<td align=\"top\" valign=\"top\" style=\"border-bottom: solid 1 #000000\"><input type=\"checkbox\" name=\"checkbox$count\" value=\"%s\" unchecked><b>%s, %s</b><br><b>Adr.:</b> %s<br><b>Tel.:</b> %s<br><b>Fréq.:</b> %s<br><b>Email:</b> %s</td>", $row[0], $row[2], $row[1], $row[3], $row[4], $row[5], $row[6]);
$count++;
$colsprinted++;
$totalitems++;
}
printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);
print("</td></tr>");
print("</form>");
print("</table>");
break;
////////////////////////////////////////////////////////////////////////

[asolell]

<input type="checkbox" name="ContactRequested" value="ContactRequested">

No need to put the Checked option unless you need it checked.

If on the other hand you use radio buttons, they are
the same priciple with the Submit buttons.

You give them all the same name. When they go over
to the processing page, the selected radio button will have
it's value transferred over and then through the switch case
you can act upon (for each radio button create a different case).

[tha_mink]

your problem is that in order for radio buttons to work as you wish them to, they need to have the same name...the exact same name so when you name them ...

checkbox$count

That is what allows you to have more than one checked.

Name the radio button the same thing but give them individual values such as rb$count or whatever. Then only one can be checked.

[npereira]

For some reason, this script is doing some funny stuff with the check box. If I change the value to reflect the same as the name, (ie: checkbox$count) and change the input type to radio, the script malfunctions, ie: when selecting the record and than clicking the edit button, the record does not come up. only a blank screen.

Regards,

Nelson

[tha_mink]

Post your code.

[juschillinnow]

The code wasn't made for radio buttons, Sorry.

The reason it doesn't work is because the receiving end of the script depends on it having a different name in order to pull the information off of the database using the value of the radio button. If you name them the same, it will pull all of the same record, if even that!

[npereira]

You are right,

It does not bring up any records at all.