odbc_do

To clear up: the SQL standard requires strings to be inside single quotes: 'string'.  It simply does not accept double quotes for this purpose.Furthermore, in PHP, you can have a single quote inside double quotes: "select a from b where c = 'string'" without the need to escape.

Hey guys,I used the following code to run normal double quotes inside my SQL queries. Hopefully this will save someone else a headache or two-<?php    /**     * Query Function     * Allows quoted queries to be sent to SQL     */    function query($query, $conn)    {        odbc_do($conn, 'SET QUOTED_IDENTIFIER OFF');        return odbc_do($conn, $query);    }?>

i have use this function so many times. it works well for my requirements. ok well done...<?php         $sqlstr="SELECT bill_no FROM SCROL";         $queryresult=odbc_do($conn,$sqlstr);         odbc_fetch_row($queryresult,$bills);        // if we want to access the records        // then we have to write the following code                 echo $bills[0];      ?>the out put for this will: 1 which is actullay first record of resultset.