> Funny you should ask - just done it myself:

Why you use mysql_result function?

This can be done a bit simpler way (and more effective):

<?php
    mysql_connect("db", $user, $password);
    $result = mysql_query( "SELECT eventName FROM $table");
    while(list($event) = mysql_fetch_row($result))
        echo "<option>$event</option>\n";
?>

Lenar

>
> <?php
>   $table="shoots";
>   require ("connect.php4");
>   $result=MYSQL_QUERY( "SELECT eventName FROM $table");
>   $num_rows = mysql_num_rows($result);
>
>   for ($i=0;$i<$num_rows;$i++)
>   {
>   echo "<option>";
>   echo mysql_result($result,$i,"eventName");
>   echo "</option>";
>   }
>
>
>   MYSQL_CLOSE();
> ?>
>
> - seb



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to