Wordpress - AMF SQL Query help

programming
1

Hi,

Ok, I’m trying to query a wordpress install and return posts that use a particular category.

I have an SQl query that does work, when run in phpMyAdmin, but am having trouble translating it into PHP code that works with AMFPHP.

Heres the SQL

SELECT p.post_title, wpr.object_id, wp_terms.name
		FROM wp_terms
		INNER JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id
		INNER JOIN wp_term_relationships wpr ON wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
		INNER JOIN wp_posts p ON p.ID = wpr.object_id
		WHERE taxonomy =  "category"
		AND p.post_type =  'post'
		ORDER BY object_id
		LIMIT 0 , 30

Edit - Figured it out.!