Auto increament with text

[jeeva]

hi frnds,

 

i want generate a random number with text. For example i have to give one Reference number for a requisition whenever user submit the requisition.For that i need to create one random number like  GMS0001,GMS0002,GMS0003......etc,. and it will be stored in database.

Based on this reference id i have to show the data for user so it must be unique and auto increament. 

 

I know i will get this by using rand() function, but it has to come with text and order. 

 

 

any one can help me?

[jaikar]

 

easiest way is to have 2 columbs for the record ID and the reference number seperatly. the recordID will get auto incremented, so while inserting a record, get the last record

 

$last_record = mysql_result(mysql_query('SELECT recordID FROM table ORDER BY recordID DESC LIMIT 1'), 0);

$referencenumber = 'GMS'.($last_record++);

 

inlcude the ref number while inserting the record.

 

you can also do this with having one column alone, then you have to do code it php according to your requirement..

 

 

[jeeva]

i guess it will help me...thank u very much....