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 Quote Link to comment 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] Quote Link to comment Share on other sites More sharing options...
c_shelswell Posted January 12, 2007 Author Share Posted January 12, 2007 great thanks very much ;D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.