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
