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
Hapgood - Strickland [mailto:[EMAIL PROTECTED] Sent: donderdag 28 oktober 2004 17:19 To: [EMAIL PROTECTED] Subject: [PHP] trying 2 pull data out table and populate a list box I am trying to pull all data out of a table called "province" which has 2 fields "ProvinceID" and "Descr

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

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

2004-10-28 Thread Garth Hapgood - Strickland
I am trying to pull all data out of a table called "province" which has 2 fields "ProvinceID" and "Description" respectively. Now I want to populate a list with all the data in the "descriptions" field. Many thanx -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://w