PROB WITH FINDING NEXT SEQUENTIAL NUMBER IN DATABASE FOR AN INSER T
| From: | Sonya Davey / QDCEL | Date: | Mon, 20 Nov 2000 14:37:48 +0000 |
| Subject: | PROB WITH FINDING NEXT SEQUENTIAL NUMBER IN DATABASE FOR AN INSER T | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-26268@lists.php.net to get a copy of this message | ||
HI, WOULD APPRCIATE ANY HELP ON THE FOLLOWING:
IF I WANT TO GET THE NEXT SEQUENTIAL NUMBER(IE LASTCLIENTNO +1) FROM THE
CONTROL TABLE IN MY DATABASE
TO DO AN INSERT INTO A DATABASE ASWELL AS PREFIXING THAT NUMBER WITH ADM,
HOW WD I DO THIS?
$SelectClientNumberDetailQuery="SELECT LASTCLIENTNO
FROM CONTROL
WHERE CODE=1";
$SelectClientNumberDetailQuery_Result=ibase_query($SelectClientNumberDetailQ
uery,$connection);
$SelectClientNumberDetailRow =
ibase_fetch_row($SelectClientNumberDetailQuery_Result);
THANKS FOR ANY HELP!