Re: Query Results Question

* Thus wrote Harlequin: > 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. <stab in="the dark">mysql_error()</stab> Curt -- First, let me assure you that this is not one of those shady pyramid schemes you've been hearing about. No, sir. Our model is the trapezoid!