Re: radio buttons from MySQL query?

oups ... you're right ! ----- Original Message ----- From: "John Nichel" <jnichel@by-tor.com> To: <rija@vatu.com> Cc: "php" <php-general@lists.php.net>; "David Jackson" <info@mustardandrelish.com> Sent: Monday, November 04, 2002 2:57 PM Subject: Re: [PHP] radio buttons from MySQL query? > 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" <info@mustardandrelish.com> > > To: <php-general@lists.php.net> > > 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 > >> > >> > > > > > > > > > >