Re: Generating readio buttons

Peter Beckman wrote: Peter, Thanks for your prompt reply.

Gonna need some additional information, such as: 1. The first three rows your query returns 2. The expected output 3. The actual problem and/or error.

What I'm trying todo is build a radio box form for the selection of ledger accounts for a account app. ( http://mustardandrelish.com/ledger) Query returns (from HTML table): <input type="radio" name="gl_acct" value=acct[]"> <input type="radio" name="gl_acct" value=acct[]"> <input type="radio" name="gl_acct" value=acct[]"> Expected results might be: <input type="radio" name="gl_acct" value="1000" "> <input type="radio" name="gl_acct" value="2000" "> <input type="radio" name="gl_acct" value="3000" "> And then "gl_acct" will be passed to the G/L entry screen (sticky forms?) TIA, David

Peter On Sun, 3 Nov 2002, David Jackson wrote:

Howdy -- How do I dynamically generate the "value" for radio buttons off the DB (MySQL) backend? Here's some code that almost works TIA, David --------------------- Almost works ---------------------------- <?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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

---------------------------------------------------------------------------

Peter Beckman            Systems Engineer, Fairfax Cable Access Corporation
beckman@purplecow.com                             http://www.purplecow.com/

---------------------------------------------------------------------------