So the db structure looks like this
tablename(uniqueid, categoryname, categoryid)
I want to be able to generate a number that would be unique where categoryname="something"
Example, I can have the categoryname as 'something', and there are 5 different rows with the categoryid 1,2,3,4,5. and another categoryname as 'somethingelse', and there are 3 different rows categoryid of 1,2,3.
Since auto_increment wouldn't work, i was wondering if I can do that via php?