Re: Problem with Oracle
| From: | Gonzalo Vera | Date: | Wed, 31 Jan 2001 04:38:46 +0000 |
| Subject: | Re: Problem with Oracle | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-5283@lists.php.net to get a copy of this message | ||
> $sql_getID = "SELECT max(CUSTID_NUM) from cfull2.tbl_dl_customers";
> how the hell do I get that number into a variable?
Wouldn't changing your SQL statement to this do the trick?:
"SELECT max(CUSTID_NUM) as max_cust_id from cfull2.tbl_dl_customers"
^^^^^^^^^^^^^^
And just retrieve the value of max_cust_id as any other row of data. I
don't use Oracle, but that's how I would do it in ODBC or MySQL.
Gonzalo.