radio buttons from MySQL query?
| From: | David Jackson | 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!";}
?>