Re: php access query problem

From: Date: Fri, 09 Feb 2001 19:36:22 +0000
Subject: Re: php access query problem
References: 1 2  Groups: php.windows 
Request: Send a blank email to php-windows+get-5486@lists.php.net to get a copy of this message
Access 2000 on IIS 4.0 "Gonzalo Vera" <gvz@eucalipto.net> wrote in message news:627380912.20010208164816@eucalipto.net... 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'"); -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

« previous php.windows (#5486) next »