RE: [PHP] Query Results Question
| From: | Richard Bewley | Date: | Wed, 04 Aug 2004 01:03:18 +0000 |
| Subject: | RE: [PHP] Query Results Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-192642@lists.php.net to get a copy of this message | ||
Hi,
Take the spaces out of your field names, and then use this:
<?php
$query = mysql_query("SELECT
id,vacancy_role,vacancy_salary,vacancy_location,vacancy_type FROM
vacancy_details WHERE Public='yes'");
while($result = mysql_fetch_array($query)) {
echo "$result[id] - $result[vacancy_role]";
}
?>
-----------------------------------------------------------------
Thank you,
Richard Bewley
rbewley@eq-sys.com
Equinox Systems and Development
Website: http://www.eq-dev.com/