Re: php access query problem
| From: | Gonzalo Vera | Date: | Thu, 08 Feb 2001 22:48:16 +0000 |
| Subject: | Re: php access query problem | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-5473@lists.php.net to get a copy of this message | ||
What DB are you using?
Gonzalo.
> 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'");