php access query problem
| From: | aaron | Date: | Thu, 08 Feb 2001 22:44:31 +0000 |
| Subject: | php access query problem | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5471@lists.php.net to get a copy of this message | ||
I have the query
$cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
Equipment01 WHERE Location = '415C'");
which returns the proper results but when I add AND 'Equip Type' = 'C' to
the end of it I get no results. Is my syntax correct? Thanks, Aaron
$cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
Equipment01 WHERE Location = '415C' AND 'Equip Type' = 'C'");