Re: odbc_exec() act funny.....
| From: | Scott Fletcher | Date: | Tue, 15 Oct 2002 19:13:15 +0000 |
| Subject: | Re: odbc_exec() act funny..... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120062@lists.php.net to get a copy of this message | ||
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" <jay.blanchard@niicommunications.com> wrote in message
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
>