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<$aantal_ladders;$x++)
>         {
>                 $rijladders["$x"]=mysql_fetch_array($rsladders);
>         }

if ( mysql_num_rows( $rsladders ) )
{
    while ( $rijladders = mysql_fetch_array( $rsladders ) )
    {
echo <<<EOF
<option value="$rijladders[ladder_id]">$rijladders[laddername]</option>
EOF;
    }
}

> 
> And then to populate the list:
> <select name="ladder" id="select">
>           <?PHP
>     for($x=0;$x<$aantal_ladders;$x++)
>     {
>       echo('<option value="'.$rijladders["$x"]["ladder_id"].'"');
>       echo('>'.$rijladders["$x"]["laddername"].'</option>');

Like I wrote above, I tend to use heredoc syntax for stuff like this.


-- 
Greg Donald
Zend Certified Engineer
http://gdconsultants.com/
http://destiney.com/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to