RE: [PHP] trying 2 pull data out table and populate a list box

2004-10-29 Thread Reinhart Viane
L PROTECTED] Subject: Re: [PHP] trying 2 pull data out table and populate a list box Thanx so much Reinhart It works fine now. Ok so i have my list populated now. IF I want to diplay "select one" at the top of the list box, not as an option, but just so that the user knows to select a

Re: [PHP] trying 2 pull data out table and populate a list box

2004-10-29 Thread Garth Hapgood - Strickland
Thanx so much Reinhart It works fine now. Ok so i have my list populated now. IF I want to diplay "select one" at the top of the list box, not as an option, but just so that the user knows to select an item. How will I put that in the code? Greets Garth -- PHP General Mailing List (http://www.

RE: [PHP] trying 2 pull data out table and populate a list box

2004-10-29 Thread Reinhart Viane
>if ( mysql_num_rows( $rsladders ) ) >{ >while ( $rijladders = mysql_fetch_array( $rsladders ) ) >{ >echo <<$rijladders[laddername] >EOF; >} >} >Like I wrote above, I tend to use heredoc syntax for stuff like this. This indeed seems to be a faster way. Can you point me out the <

Re: [PHP] trying 2 pull data out table and populate a list box

2004-10-29 Thread Greg Donald
On Fri, 29 Oct 2004 09:52:49 +0200, Reinhart Viane <[EMAIL PROTECTED]> wrote: > I always do this with a script like this: > > $sql="select * from ladders order by laddername"; > $rsladders=mysql_query($sql); > $aantal_ladders=mysql_num_rows($rsladders); > > for($x=0;$x<$aa

RE: [PHP] trying 2 pull data out table and populate a list box

2004-10-29 Thread Reinhart Viane
I always do this with a script like this: $sql="select * from ladders order by laddername"; $rsladders=mysql_query($sql); $aantal_ladders=mysql_num_rows($rsladders); for($x=0;$x<$aantal_ladders;$x++) { $rijladders["$x"]=mysql_fetch_array($rsladders)

Re: [PHP] trying 2 pull data out table and populate a list box

2004-10-28 Thread Rens Admiraal
you mean: $query = " SELECT ProvinceID, Description FROM province ORDER BY Description ASC "; $result = @mysql_query ($query, $connection) or die (mysql_error()); while ($row = @mysql_fetch_array($result)) { $options .= "{$row["Description"]}\n"; } $selectBox = "\n" . $options . "\n"; echo $se