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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to