[PHP] Dynamically generate a drop down list

[Mukta Telang]

Hi,
I want to dynamically generate a drop down list of "authors" by querying
a database. What I am doing at present is:

function init_auth_list($auth_list)
{
        $auth_list="<select name=author> <option value=\"\">select the
name of t
he author</option\>";
        $query="select name from author order by name";
        $result=pg_exec($GLOBALS["db"],$query);
        $numrows=pg_numrows($result);
        $i=0;
        while($i<$numrows)
        {
        $row=pg_fetch_row($result,$i);
        $auth_list=$auth_list."<option
name=\"$row[0]\">$row[0]</option>";
        $i++;
        }
        $auth_list=$auth_list."</select>";
        return $auth_list;
}


and then I just echo $auth_list.

Is it possible to have a function which echoes the values as they are
read from the database?

I tried doing something of this sort..but didn't work..
Any suggestions?
Thanks in advance,
Mukta

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