[Rich]

I am currently working on a reciprocals list for one of my sites. I am wishing to display the results in a series of pages so the page isn't umpteen miles long.

I have the pagination itself working, except it isn't sorting by category. instead, everything is being shown in each category, just broken up by pages. lol

I am speculating that it has to do with this query, and I likely have it written wrong:

  $get_recip = $vbulletin->db->query_read("
	    SELECT recipid, categoryid, sitetitle, username, userid, sitelink, sitelinkimg, aboutme, views, votes, rating, joindate, active
        FROM " . TABLE_PREFIX . "recip_links
        WHERE active=1 ORDER BY joindate DESC
	    LIMIT " . ($limitlower - 1) . ", $perpage
		");

I tried to set "order by" to category, but that did nothing. I have tried several different things over the past couple hours but i am about ready to pull my hair out.

Could someone lend this schmuck a hand sorting out why it isn't displaying by category.