MySQL SELECT problem

[stonefish]

hi,

I have a table with columns as follows -

id - cat - subcat

I want to write a select statement that will group all the cat fields together, but then list out all the subcat values after printing the cat value. Once all the subcat values are printed for that cat, then it moves onto the next cat.

Thanks

[NogDog]

That is typically done via a combination of SQL and PHP. You use a GROUP BY clause in the SQL to group on the desired field, then within the PHP loop on the result rows you check to see if the value of the grouped column is different than on the last iteration; and if so you output the group heading.