-----Original Message----- From: Harlequin To: [EMAIL PROTECTED] Sent: 04/08/04 01:55 Subject: [PHP] Query Results Question
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. -------------------------- I may be wrong, as I don't use mySQL, but shouldn't those be back-ticks around the column names and not single quotes? With the quotes, you're just asking the database to return the literal text as if it were a column value. Back ticks are used to enclose column names that contain non-alphanumeric characters. Cheers! Mike 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 ----------------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
