Richard Thanks firstly for your help. I renamed the fields so the spaces are underscores and amended your query but still receive an error:
"not a valid MySQL result resource " Still tinkering though... -- ----------------------------- Michael Mason Arras People www.arraspeople.co.uk ----------------------------- "Richard Bewley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
