c_shelswell Posted January 12, 2007 Share Posted January 12, 2007 I need to make an invoice number at purchase confirmation on my site. My idea is that there will be a database query to get the last invoice number then add one to that number and input the new number on a new line with the relevant purchases.I was going to use auto increment but the problem is that if a user purchases 3 items i need the invoice number to be the same for all 3 items.Can anyone see any problems with my top method if there will be many users purchasing at the same time? I need the numbers to be unique obviously.Cheers Link to comment https://forums.phpfreaks.com/topic/33910-incremental-invoice-number-generation/ Share on other sites More sharing options...
taith Posted January 12, 2007 Share Posted January 12, 2007 [code]$result=msyql_query("SELECT MAX(id) FROM invoices");$row=mysql_fetch_array();$newid=$row['MAX(id)']+1;[/code] Link to comment https://forums.phpfreaks.com/topic/33910-incremental-invoice-number-generation/#findComment-159201 Share on other sites More sharing options...
c_shelswell Posted January 12, 2007 Author Share Posted January 12, 2007 great thanks very much ;D Link to comment https://forums.phpfreaks.com/topic/33910-incremental-invoice-number-generation/#findComment-159209 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.