My CMS is coming along, but I've run into a problem.
My system gives each item a unique id (auto_increment). Each item is also identified by its title. There may be more than one page in an item; in that case, each page gets its own row. As a result, there are some rows that have identical titles. The unique id is not used by my script and is merely there to ensure no two rows are identical.
I want now to be able to create a list of all my items, but the catch is I don't want items with multiple pages to be listed more than once. Only the first page in an item shall be displayed.
Is there any way with MySQL or PHP to filter the extra rows out such that when everything is processed, there is only one instance of each title in my list?
This is for the backened, so I'm not really concerned with the number of queries, but is there an efficient way to do this?