There is no reason to put brackets behind the name of the radio element.  The brackets are neccessary for multi-select elements like checkboxes, but radio buttone are a single select element.

Your if statement should be a while loop.

I'm sure you don't want to set this ( value=acct[] ) as the value for each radio button.  Do it that way, and no matter which one is picked, it will be the same value.

rija wrote:
I don't think so,
Put the bracket with your radio's name not with your the value///

For example :
print "<td width=2><input type=radio name=gl_acct[]
value=$row['acct']>{$row['acct']}</td>" ...
and so one/

----- Original Message -----
From: "David Jackson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 1:15 PM
Subject: [PHP] radio buttons from MySQL query?



How do I go about building radio buttons using the results of a MySQL
query. The record layout looks like this:

acct
cat
description

I want to use acct as the value="acct" in the input statement for the
radio box. The code below almost works?

TIA,
David


<?php
$header = mysql_query ("SELECT * FROM chart
           ORDER BY acct ");

if ($row = mysql_fetch_array($header)) {
        do {
        print("<tr  bgcolor=\"white\" >");
   print '<td width="5"><input type="radio" name="gl_acct"
value=acct[]"></td>';
   print("<td width=\"12\">");
   print $row["acct"];
        print "</td><td width=\"12\">";
   print $row["cat"];
        print "</td><td >";
   print $row["descript"];
   print("</td></tr>\n");
               } while($row = mysql_fetch_array($header));

            } else {print "Sorry, no records were found!";}


?>


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







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

Reply via email to