When I try to do the two seperate SQL command with the 2nd odbc execution right after the 1st odbc execution. It work fine. Weird!!!!!!
--clip-- //SQL Command #1 $ask = "SELECT * FROM CUSTOMERS "; $ask .= "WHERE CUSTOMERS.CUSTOMER_ID = '".$_POST['Customer_Id']."'"; //SQL Command #2 $ask = "SELECT * FROM USERS "; $ask .= "USERS.USER_LOGON1 = '".$User_Logon1."' AND "; $ask .= "USERS.USER_PASS1 = '".$User_Pass1."' "; --clip-- "Jay Blanchard" <[EMAIL PROTECTED]> wrote in message 000901c2747b$ccaffc00$8102a8c0@000347D72515">news:000901c2747b$ccaffc00$8102a8c0@000347D72515... > [snip] > With odbc_exec() function, it is able to execute and retrieve the data > pretty well. Unfortunately, when the number of fields grow and grow then > the odbc_exec() return false and a blank data. I don't get it! When I run > the SQL command through the database interface, it work like a charm. So, > it is a PHP issue. > > Is it a PHP bug? What's up with that????? > [/snip] > > Can we see the code involved? > > Jay > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php