Re: foreach loop from MySQL select query to HTML selectlist

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

 



On Wed, 2002-11-27 at 23:33, Gavin Amm wrote:
> Hi,
> 
> I'm trying to pick up data from my MySQL database, use a foreach loop to
> extact the data from the result & put that data into a select list.
> 
> I have tried the following code with & without the $row = ... line, both
> unsucessfully:
> 
> <?PHP
> $db = mysql_connect("myhost", "username", "****");
> mysql_select_db("mydatabase", $db);
> 
> ## FETCH INFO
> $sql_dept = "SELECT dept FROM content GROUP BY dept";
> $sql_deptsub = "SELECT deptsub FROM content GROUP BY deptsub";
> 
> mysql_close($db);

How can run a query when it's closed? move this to after the select and
see if it works.
> ?>
> 
> 
> <select name="dept">
>   <option>-select-</option>
>     <?PHP
> 	$result = mysql_query($sql_dept, $db);
> 	$row = mysql_fetch_array($result);
> 	foreach ($row as $value) {echo "<option
> value=\"$value\">$value</option>\n";}
>     ?>
> </select>

Put your mysql_close here if you want to close it.

John Coder


-- 
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