title: Customise Unique Id generate in PHP , MySql
body: <p>I want little help in creating automated but custom id for each item i store in mysql database. Like if i enter 1 item of pepe jeans color "black" and waist 30. the unique id for this product will be PEPE+BLACK+30+A001, A001 is an unique number which will increase like A001, A002, A003....A999 after reaching A999 this number will become B001 and then B002,B003....so on. Plz show me the logic to do this. </p>
  
  <p>Example of 1 item id will be: PEPEBLACK30A009</p>
  
  <p>#thanks :)</p>