Yeah ive got it originally indexed like this, but i got a lot of complaints that people didnt want to click the category AND click a letter after that...
1. So i changed it the way it was now... I didnt really liked it either. I guess this will be the solution everyone may like :S :P
2. Every item has its own id, set as primary key and auto_increment
And the last one, will this result faster lookup? Its set like this right now:
WHERE `name` LIKE '%".$id."'
I guess that would get my result just as fast?
Anyway, thanks a lot
