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
[EMAIL PROTECTED]
Equinox Systems and Development
Website: http://www.eq-dev.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
