In a database table we can't give two auto-increments. But i have a requirement in which another auto-increment is required.So please give me a suggestion how to get another auto-increment.
You can't use two auto-increments in the same table because it causes conflicts. Why not create another table and use JOIN/JOIN LEFT/JOIN RIGHT etc etc. Or you can write in the PHP code to increase ++$value in your selected column everytime the method happens
You could also do a two step process with only one of them being auto-correct. Basically, create the record how you normally would (with the first auto-increment NULL). Then search for that entry (that you just entered) and get the value of the auto-increment. Then update that record to make the second auto-increment equal to that value. Bit annoying, but it would work. You could also keep a running total of the high auto-increment to reference and just base the second auto-increment on that.