conditional statement for php query to oracle
Posted on 2009-02-18
I'm very new to PHP, I'm really more familiar with Coldfusion, but I find myself needing to do something quick in php. So I have a query in PHP, connecting to an Oracle database...no problem with the connection or the initial query, but when I put a where statement in, things stop working....so I know I'm doing something wrong. The following query works fine:
$query = 'SELECT * FROM SCHEME.INSTALLATION';
But this statement does not:
$query = 'SELECT * FROM SCHEME.INSTALLATION WHERE INSTALLATION.NUMBER = '12345'';
Can anyone shed some light on what I'm doing wrong??? Thansk Alot!!!