[Warlord]

I'm trying to query the sql database to only retrieve blogs that match a certain category but I can't figure out what the syntax is for categories.

I'm modifying an existing query that looks like this:

PHP Code:

    SELECT blogid, blog.title, blog_user.title AS blogname, comments_visible, username, dateline, userid, views

    FROM " . TABLE_PREFIX . "blog AS blog

    LEFT JOIN " . TABLE_PREFIX . "blog_user AS blog_user ON blog_user.bloguserid=blog.userid 

    WHERE blog.state='visible' and blog.pending=0 and blog_user.options_guest=3

    ORDER BY dateline DESC 

    LIMIT 5 


I've tried adding and blog.cat='Project Fanboy Columns' and other variations but none of them seem to be correct. Can anyone tell me what blog.cat should really be?

--------------- Added [DATE]1295136492[/DATE] at [TIME]1295136492[/TIME] ---------------

Nevermind, I figured it out.

For anyone who's interested, it's blog.categories, which I could've sworn I had tried before but I guess not.

Also, you have to input the category ID, not the actual name of the category (string). So it looks like this:

blog.categories='10'

instead of

blog.categories='Project Fanboy Columns'