[PHP] PHP/MySQL best practice tutorial

I have a mySQL database containing items that are categorised four levels deep. when I'm getting the data out (in a tree structure) I'm nesting SQL queries inside array traversing loops (select distinct category, while $row= echo stuff select distinct subcat, while $row= echo stuff etc) I'm sure

RE: [PHP] PHP/MySQL best practice tutorial

Tony Crockford mailto:[EMAIL PROTECTED] on Tuesday, July 29, 2003 10:23 AM said: I have a mySQL database containing items that are categorised four levels deep. [snip] can anyone point me to a tutorial that would help me switch from nested select statements to something more elegant?