Re: [PHP] generating next number... from db extraction

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

RE: [PHP] generating next number... from db extraction

Thanks for your help John that works really well :) Cheers Peter -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 May 2002 12:08 PM To: 'Peter'; 'Php' Subject: RE: [PHP] generating next number... from db extraction Okay...here&#x

RE: [PHP] generating next number... from db extraction

happy b/c it looks like they want and you'll be happy b/c you're using an auto_increment column. ---John Holmes... > -Original Message----- > From: Peter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 9:38 PM > To: Php > Subject: RE: [PHP] generating next num

RE: [PHP] generating next number... from db extraction

update ... -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED]] Sent: Thursday, 30 May 2002 11:22 AM To: 'Peter'; 'Php' Subject: RE: [PHP] generating next number... from db extraction Why does it have to be letters and numbers? You're just making

RE: [PHP] generating next number... from db extraction

o, but you could try that. www.php.net/uniqid ---John Holmes... > -Original Message- > From: Peter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 8:28 PM > To: Php > Subject: [PHP] generating next number... from db extraction > > hi, > > I'

[PHP] generating next number... from db extraction

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 = a