increment by one
| From: | kevin at oceania dot net | Date: | Mon, 10 Jul 2000 21:18:15 +0000 |
| Subject: | increment by one | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-5830@lists.php.net to get a copy of this message | ||
I have a table with a ReceiptID that increments from another table
rather than auto_increment but it does not work,
What I need to do is make the $ReceiptID increment by one
$queryReceiptID="SELECT ReceiptID FROM Items ORDER BY ReceiptID DESC
LIMIT 1";
$resultReceiptID=MYSQL_QUERY($queryReceiptID);
while($row = mysql_fetch_array($resultReceiptID)) {
$ReceiptID=$row[ReceiptID];
Kind regards
Kevin