RE: foreach loop from MySQL select query to HTML select list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> hmm, interesting to know the mysql_fetch_array() by default returns an
> array
> that's associative AND numeric - very useful to know & something i'll
have
> to look into more, thanks Jason.
> 
> Thanks also John, puting curley braces around the variables is a
valuable
> lesson - works wonderfully - cheers.
> 
> i do have one more problem though, i need to run the loop a 2nd time
later
> in the page in exactly the same way, but nothing is returned.
> i just copied & pasted the code from one section of the page to the
next.
> do i need to reset one of the vaiables?
> 
> 
> <select name="dept">
>   <option>-select-</option>
>   <?PHP
>   while($row = mysql_fetch_array($result_dept)){
>     echo "<option value=\"{$row['dept']}\">{$row['dept']}</option>\n";
>   }
>   ?>
> </select>

Put the options into a variable and just echo it out where you need it.

$options = "<option>-select-</option>\n";
while($row = mysql_fetch_row($result))
{ $options .= "<option value=\"{$row[0]}\">{$row[0]}</option>\n"; }

And wherever you need a select statement, just 

<select name="dept">
<?=$options?>

---John Holmes...



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux