WordPress › Support Topic: How to showcase TWO different posts using > query

WordPress › Support Topic: How to showcase TWO different posts using > query_posts http://wordpress.org/support/ WordPress › Support Topic: How to showcase TWO different posts using > query_posts en Mon, 06 Jul 2009 00:22:39 +0000 amylooo on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-501145 Sat, 20 Jan 2007 00:23:25 +0000 amylooo 501145@http://wordpress.org/support/ I have the same error on the index page at <a href="http://www.amyloo.com/clipoftheweek" rel="nofollow">http://www.amyloo.com/clipoftheweek</a> Like one of the first posters in this thread, it happened after I added a query_post -- in my case to exclude a particular category of posts from the index. Like the just-previous poster, I isolated the troublemaker. It's the theme; when I revert to the basic theme, the error goes away. Problem is the thememaker says my question is beyond his scope of support <a href="http://forums.wpthemes.info/comments.php?DiscussionID=126/" rel="nofollow">http://forums.wpthemes.info/comments.php?DiscussionID=126/</a> So now what? I'll likely end up starting over with a new theme based on the default rather than modifying a theme that doesn't look anything like what I ended up with anyway! But for a quick fix, I thought it might be worth asking if anybody has any ideas. Thanks. /amyloo giles on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-454833 Thu, 05 Oct 2006 21:15:31 +0000 giles 454833@http://wordpress.org/support/ I had this very same problem ... it was fixed very easily ... i went through disabling all my plugins one by one .. the 3rd plugin i disabled fixed it .. it was my Adhesive plugin that was messing it up. <a href="http://www.redalt.com/downloads/" rel="nofollow">http://www.redalt.com/downloads/</a> was where it was from .. and now doesn't seem to be kept up to date .. so if i need sticky posts i won't be using it any more ! gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-438996 Mon, 04 Sep 2006 19:45:14 +0000 gs06 438996@http://wordpress.org/support/ anyone ? gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-438249 Sun, 03 Sep 2006 14:59:48 +0000 gs06 438249@http://wordpress.org/support/ Thanks Viper007Bond. i tried it but this line >> <?php else : ?> keeps coming as error > > parse error, unexpected $ i tried to delete the line no good tried to delete <?php else : ?> <?php _e('Sorry, no posts matched your criteria.'); ?> <?php endif ?> no good suggestions ? Viper007Bond on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436976 Fri, 01 Sep 2006 05:08:18 +0000 Viper007Bond 436976@http://wordpress.org/support/ You need to add the code as I mentioned above. ;) <a href="http://pastecode.com/4030" rel="nofollow">http://pastecode.com/4030</a> gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436525 Thu, 31 Aug 2006 14:04:07 +0000 gs06 436525@http://wordpress.org/support/ sure here you go : <a href="http://pastecode.com/3993" rel="nofollow">http://pastecode.com/3993</a> Viper007Bond on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436430 Thu, 31 Aug 2006 08:46:21 +0000 Viper007Bond 436430@http://wordpress.org/support/ Please post the contents of your entire home.php or whatever: <a href="http://pastecode.com" rel="nofollow">http://pastecode.com</a> gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436327 Thu, 31 Aug 2006 01:09:46 +0000 gs06 436327@http://wordpress.org/support/ the 2 posts are there but then i get a bunch of strange error-posts : Category: Uncategorized WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_approved = '1'' at line 1] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1'; 0 Comments , Edit This Category: Uncategorized WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_approved = '1'' at line 1] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1'; 0 Comments , Edit This Category: Uncategorized WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_approved = '1'' at line 1] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1'; 0 Comments , Edit This Category: Uncategorized WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_approved = '1'' at line 1] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1'; miklb on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436312 Thu, 31 Aug 2006 00:45:56 +0000 miklb 436312@http://wordpress.org/support/ He means what was the jibrish exactly? gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436311 Thu, 31 Aug 2006 00:42:56 +0000 gs06 436311@http://wordpress.org/support/ yea exactlly got jibrish as well how do i incoperate your code to my home.php page ? Viper007Bond on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436303 Thu, 31 Aug 2006 00:28:32 +0000 Viper007Bond 436303@http://wordpress.org/support/ <blockquote>tried, but got jibrish</blockquote> Okay, what was it? gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436285 Wed, 30 Aug 2006 22:50:58 +0000 gs06 436285@http://wordpress.org/support/ Thanks tried, but got jibrish i used the code as follows: <?php get_header(); ?> <?php get_sidebar(); ?> <?php $posts = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE ID='21' OR ID='43'"); ?> this is not on my index page but home.php what am i doing wrong ? Viper007Bond on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436282 Wed, 30 Aug 2006 22:41:49 +0000 Viper007Bond 436282@http://wordpress.org/support/ I don't believe you can use <code>query_posts()</code> for that (mutliple posts), but I'm not sure. Just use this instead: <code>$posts = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE ID='21' OR ID='43'");</code> gs06 on "How to showcase TWO different posts using > query_posts" http://wordpress.org/support/topic/85423#post-436275 Wed, 30 Aug 2006 22:27:14 +0000 gs06 436275@http://wordpress.org/support/ Hi guys, sorry for the multiple questions :) I would like to showcase TWO different posts on my welcome page in my home.php I placed the query_posts tag but i get only ONE post here is the tag i am using: <?php query_posts('p=21,43'); ?> any suggestions how i get both post id=21, and below it post id=43 ? Thank you !