Query Results Question
| From: | Harlequin | Date: | Wed, 04 Aug 2004 00:55:11 +0000 |
| Subject: | Query Results Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-192640@lists.php.net to get a copy of this message | ||
I have the following query which should return just two rows:
SELECT 'ID', 'Vacancy Role', 'Vacancy Salary', 'Vacancy
Location', 'Vacancy
Type'
FROM vacancy_details
WHERE Publish = 'Yes'
As only two rows have Publish set to "Yes".
yet even if I execute the query through phpMyAdmin I get two rows with field
headings as field values.
Any suggestions on where I'm going wrong...? I'm pretty sure my query syntax
is accurate as I've used this type of query many times before and have even
checked the syntax by using a query window.
--
-----------------------------
Michael Mason
Arras People
www.arraspeople.co.uk
-----------------------------