radio buttons from MySQL query?

From: Date: Mon, 04 Nov 2002 02:15:57 +0000
Subject: radio buttons from MySQL query?
Groups: php.general 
Request: Send a blank email to php-general+get-122597@lists.php.net to get a copy of this message
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!";}
?>

« previous php.general (#122597) next »