Hello guys, me again :D This time around I'm trying to figure out how to organize some stuff...I've been pulling my hair out for a couple of hours.. (or at least what is left of it).. Crazy as it may sound, I'm trying to make some very, very simple forums for, umm, shall we say for self-learning purposes. And I am in a bit of a trouble you see, I have managed to make scripts to create/delete/edit/ categories & forums but I can't seem to be able to order them correctly :( on the forum home it should be something like Category1 -Forum1 -Forum2 Category2 -Forum1 -Forum2 I have made this SQL query, but it doesnt work entirely, how could I manage this? I mean pulling out all the categories from a dbase, and then displaying all the forums that correspond to a category id, below that category? here's my sql : $category = $db->query('SELECT * FROM forum_categories LEFT JOIN forums ON forum_categories.catid=forums.catid ORDER BY forum_categories.cat_position, forums.position ASC '); It kinda worked but while it showed all the forums, it repeated categories, should I make separate queries to get the categories and the forums?