Page 1 of 1

sybase ODBC_exec problem

Posted: Tue May 20, 2003 3:41 am
by valen53
Question here....

i connect a sybase db through ODBC.. the code display below, is work for other OBDC drive but sybase cannot. It cannot select out the data. i dunno where is contain error, anyone can help me , thank you.

Code: Select all

$query1 = odbc_exec($dw, "SELECT * FROM dw.DW_EMP") or die (odbc_errormsg()); 
while($row = odbc_fetch_array($query1)){ 
    echo "Customer Name: ".$row&#1111;EMP_ID]."<br />"; 
    echo "Customer : ".$row&#1111;NAME]."<br />"; 
    echo "<hr />"; 
&#125; 
odbc_close($dw);


ps.. odbc_fetch_array - use function ( )