Re: foreach loop from MySQL select query to HTML select list
| From: | John Coder | Date: | Thu, 28 Nov 2002 04:44:16 +0000 |
| Subject: | Re: foreach loop from MySQL select query to HTML select list | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23710@lists.php.net to get a copy of this message | ||
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