Best method of grabbing user's threads, categorised?

[Oblivion Knight]

I'm working on a little something to manage the content of my site via vBadvanced CMPS, without it being displayed publically on the forum home..

However, for the "Content Editor", I'm struggling to come up with a way to pull a user's threads AND have them categorised per forum basis. I imagine that I'll have to use an array, or a foreach loop of some kind for this - but I'm not that great with either..


Here's my current file:

<?php

// Lazy, but it works..
$userid = $vbulletin->userinfo['userid'];
$forumids = "2,6";

$prevarts = $db->query_read("SELECT threadid, title, forumid FROM " . TABLE_PREFIX . "thread WHERE postuserid = $userid AND forumid IN ($forumids) ORDER BY dateline DESC");

while ($titles = $db->fetch_array($prevarts))
{
	$tit = $titles['title'];
	$tid = $titles['threadid'];
	$fid = $titles['forumid'];

	eval('$articles .= "' . fetch_template('adv_portal_contenteditorbit') . '";');
}
$db->free_result($titles);

eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_contenteditor') . '";');

?>

While I could attempt to "borrow" some of vB's code for the 'Find all threads started by X' feature, I don't need any permission checking code because the tool is only accessible to staff anyway - and I'd rather try and understand how to code more efficiently (also, I dare say that the search.php file is a jungle of code to break down and navigate through for exactly what I require)..

[Marco van Herwaarden]

Change "ORDER BY dateline DESC" to "ORDER BY forumid, dateline DESC" in your query.

[Oblivion Knight]

Heh, perhaps I should have explained a little better..

I'm displaying the output in a select box, but I want to categorise the <option>s with <optgroup>s.
So effectively..


[high]BEFORE:[/high]

Article 3
Article 2
Article 1


[high]AFTER:[/high]

Category A
Article 3
Article 1
Category B
Article 2


Although you're right, I will need to add that to the query.!



[high]---EDIT---[/high]
I've done it by adding a count for every forumid for now..

It's kinda dirty though, so if anyone has a better way - I'd love to hear it.!