thanx for the replys guys... basically i need a PHP formula to generate a 'call refenrence code' that is unique to give out to clients whenever they log a call. this unique 'call reference code should be inserted into a mysql field within a table. all i need is a formula to get the last entered code and increment it by one - the intended code should be forumated by php by using the current date i.e. 20040101 + a numerical value i.e. 001 for the first 'call reference code' for the day. when the next call is logged, the next unique available numerical should be assigned and combined with the date to form the call reference number. hope this makes it a bit clearer. "Pete M" <pmorgan@xxxxxxxx> wrote in message news:20040610102921.4526.qmail@xxxxxxxxxxxxxxx > not sure what u want here but > have you looked at the identiry field ?? > its called auto_increment in mysql and this gives it record in a > database a unique number > > eg > "Insert into table (date_call)values(now() )" > > then after the insert do > "select last_insert_id()" > > pedro > > Gawie Marais wrote: > > hi all, > > > > i need to create an automatic call reference. i though it would work using > > the date as ccyymmdd and by adding a '001', '002', etc to the end. > > > > now, i know how to format the date but how would i increment the 001, 002 at > > the end... ? i understand that i would have to check back to the database to > > check the last one used. but how... ? > > > > alternatively is to just generate a random number, check it against the > > database to see if it's not already used. if not use it. if its used > > already, just create another one... ? > > > > OR > > > > do you guys have any laternative suggestions ? > > > > > > Regards, > > > > Gawie. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
