I have a database with rss feeds with each feed having one or more categories. What I'm trying to do is display the feeds within their respective categories. My first step though, I can't figure out the best way to get the categories organized.

Feed 1 / Local News / New York
Feed 2 / Local News / LA
Feed 3 / World News

I don't imagine having thousands of different feeds, so I did a query putting everything into an array.

So, here's what I have so far. (It's laughable, I know...)

$rssSelect = "SELECT * FROM rss";
$rssSet = mysql_query($rssSelect);
while ($rssRow = mysql_fetch_array($rssSet)) {
	$mainCats[] = $rssRow['id'];
Code is incomplete of course. I want all the "Local News" into an array with each feeds 'id' being linked to it. I then want sub categories linked to the main category. (In this way I hope to be able to sort through them to produce the necessary HTML). I'm having trouble figuring out how to get it done with the fewest lines/variables as possible.

This would be nice:
Local News = (1, 2)
World News = (3)

New York = (Local News)
LA = (Local News)

I should be able to sort through stuff from there... I hope I'm making sense. Thanks!