Hi You could use the auto increment feature of mysql and store the prefix and suffix as seperate fields in the database like idnum|prefix|suffix|data........ 1234:abc|A
Then just add them together to form the complete order number. Tom At 10:27 AM 30/05/2002 +1000, Peter wrote: >hi, > >I'm making a quoting system and need to have letters & Numbers inside the >quote number. Now if I was to grab the last quote number inserted into the >db and then do something like > >//example of $quoteID value w/out letters >$quoteID = 20120250; >//example of $quoteID with letters >//$quoteID = abc20250; > >$quoteNUM = $quoteID + 1; >echo $quoteNUM; > >it will work fine .. but the minute i add a letter to this is doesn't... now >I know I can generate random numbers and letters but I need to have some >order about it so the quote numbers are not all over the place... Also as an >addition providing I can get this working .. I would also like to have it so >that if a quote was updated the quoteID would be changed ... eg: if the >quote number was abc20250 after it was updated it would be abc20250-A or >something along those lines ... > > > >Cheers > >Peter >"the only dumb question is the one that wasn't asked" > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
