foreach loop from MySQL select query to HTML select list

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

 



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);
?>


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


I get the following error message in my HTML output code:

<b>Warning</b>:  1 is not a valid MySQL-Link resource in
<b>/home/.../public_html/content.php</b> on line <b>48</b><br>
<br>
<b>Warning</b>:  Invalid argument supplied for foreach() in
<b>/home/.../public_html/content.php</b> on line <b>49</b><br>

Line 48 is the line begining with: foreach...


Any help would be appreciated.
Thanks,
Gav


This e-mail and any attachments are intended solely for the named addressee,
are confidential and may contain legally privileged information. 

The copying or distribution of them or of any information they contain, by
anyone other than the addressee, is prohibited. If you received this e-mail
in error, please notify us immediately by return e-mail or telephone +61 2
9413 2944 and destroy the original message. Thank you. 

As Email is subject to viruses we advise that all Emails and any attachments
should be scanned by an up to-date Anti Virus programme automatically by
your system. It is the responsibility of the recipient to ensure that all
Emails and any attachments are cleared of Viruses before opening. KSG can
not accept any responsibility for viruses that maybe contained here in.
Please advise KSG by return Email if you believe any Email sent by our
system may contain a virus. It should be noted that most Anti Virus
programmes can not scan encrypted file attachments (example - documents
saved with a password). Thus extra care should be taken when opening these
files. 

Liability limited by the Accountants Scheme, approved under the Professional
Standards Act 1994 (NSW). 



Level 4 
54 Neridah Street                PO Box 1290 
CHATSWOOD   NSW   2067           CHATSWOOD   NSW   2057 


Ph: +61 2 9413 2944              Fax: +61 2 9413 9901

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