Characters in MySQL insert ID

63 Views Asked by At

Im kind of new to mysql and php so here we go!

At the moment the $inserted_Claim_id returns 1,2,3 etc. but i want it to have my own personal reference number before the numbers; IE; ACL0123

What i have is this;

createClaimRef($inserted_Client_ID,$Claim_Type_Code,$Claim_Type_ID);
$inserted_Claim_id=mysql_insert_id();

any help would be much obliged,

Regards

Andrew

0

There are 0 best solutions below