Re: Query Results Question

Richard. Public. I changed it to "Publish". But if I use a query window to interrogate the database I still get just two rows using the following query with field names not values for the row cell contents: SELECT 'ID','Vacancy_Role','Vacancy_Salary','Vacancy_Location','Vacancy_Type' FROM vacancy_details WHERE Publish='Yes' -- ----------------------------- Michael Mason Arras People www.arraspeople.co.uk ----------------------------- "Richard Bewley" <rbewley@eq-sys.com> wrote in message news:php.general-192646@news.php.net... > > 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... > > Can you paste me > a.) Your database structure > b.) The exact query you are using > > Also, you may want to do $query = mysql_query("SELECT * from > vacancy_details") or die(mysql_error()); > > I don't care about the first part of that, but try putting in the > mysql_error() in the form I used above, and see if it gives you any other > information. > > ----------------------------------------------------------------- > Thank you, > Richard Bewley > rbewley@eq-sys.com > > Equinox Systems and Development > Website: http://www.eq-dev.com/ > > Also, please look at our webhosting services, specializing in business web > hosting starting from $15 per month!