I use wordpress as the back-end for my news posts on my main site. I post updates to my software via posts in a certain category. I want to be able to display a list of posts that were posted in a specific category on a page that is not part of WordPress. I already do this for the front page news posts, but I can't figure out how to limit the SQL select results based on a certain category. I thought about just starting every post with a certain word and doing a LIKE "word%" but I rather actually do a "select * from table where category=#" if possible. All the category #s in the posts table are set to 0 so I have no idea how WordPress is able to know what post belongs to what category.
Is there an easy way to do this? I did a little googling but I can't find anything relevant.