mysql auto increment

[cool84]

hai,

1. i need help on how to set the auto incremental
as "REF0001","REF0 02","REF003",.. .....and so on.

2. i declare the field as integer but i want the prefix "REF" follow by the
increment number .

3. I want every time the user insert their data via the php form the reference number automaticly insert in the mysql database.


I declare the field in mysql database as

field -reference_no
Type-int(11) , auto_increment

[Motoma]

This is unnecessary. When you do your select statement, add the "REF" string to the front of your ID. You can even pad it with extra zeros if you want.