Re: Query Results Question

I'm only selecting a few fields Richard as I want to try and drop them into an array and display in a table. I know I'm probably going the long way around doing this but I need to learn from scratch exactly how to do it. I appreciate your help and patience very much. I've managed to get the query returning some results now. An array. I'm going to have to spend a little, well actually quite a bit, of time now working out how to present these in a table. I assume a for statement will get me pointing in the right direction...? -- ----------------------------- Michael Mason Arras People www.arraspeople.co.uk ----------------------------- "Richard Bewley" <rbewley@eq-sys.com> wrote in message news:php.general-192649@news.php.net... > > 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' > > Take out the quotes. Make your query say: > SELECT > ID,Vacancy_Role,Vacancy_Salary,Vacancy_Location,Vacancy_Type FROM > vacancy_details WHERE Publish='Yes'; > > Also, if you are selecting every field, then why not do a SELECT *? > > ----------------------------------------------------------------- > 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! > > > > -- > ----------------------------- > 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! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php