I’m using WordPress to update a Flash news feed. The mySQL post data is fed directly into Flash via a simple php file.
It was working fine, until I added images to the mix, using the “Meta Image” plugin…(http://no.oneslistening.com/151)
Now it seems that images which don’t have a meta image don’t show up in my list of articles.
So at http://www.thirdeyedesign.co.uk/news/wptest3.html you can’t see the third story, because it doesn’t have an image.
So, if anyone could help me tweak my code so that posts without an image show up, I would be very very grateful!
$qResult = mysql_query ("SELECT * FROM wp_posts, wp_post2cat, wp_postmeta, wp_categories WHERE wp_posts.ID=wp_post2cat.post_id AND wp_post2cat.post_id=wp_postmeta.post_id AND wp_posts.post_status='publish' AND wp_post2cat.category_id=wp_categories.cat_ID AND wp_categories.cat_name='$category' ORDER BY ID DESC");
- The topic ‘Be nice and help a newbie with php/mysql’ is closed to new replies.