http://wordpress.org/support/ WordPress › Support Tag: query en Thu, 26 Nov 2009 06:11:11 +0000 http://wordpress.org/support/topic/334105#post-1294110 Thu, 26 Nov 2009 02:40:36 +0000 gbaka 1294110@http://wordpress.org/support/ <p>I'm putting it in the index code and I'm seeing the problem in the order it doesn't seem to be in modified order. </p> http://wordpress.org/support/topic/334105#post-1293898 Wed, 25 Nov 2009 21:46:26 +0000 MichaelH 1293898@http://wordpress.org/support/ <p>Just so I can test this, what <a href="http://codex.wordpress.org/Templates">template</a> (e.g. index.php, archives.php} are you putting the code in and where are you seeing the problem? I'll be using the WordPress Default theme. </p> http://wordpress.org/support/topic/334105#post-1293855 Wed, 25 Nov 2009 21:11:37 +0000 gbaka 1293855@http://wordpress.org/support/ <p>okay it didn't change it, all the modified post seem to go by the original date and not the modified date and its messing up the updated order. So older post don't show up on the modified page. </p> http://wordpress.org/support/topic/334105#post-1293337 Wed, 25 Nov 2009 14:40:01 +0000 MichaelH 1293337@http://wordpress.org/support/ <p>May need to put <code>remove_filter(&#39;posts_where&#39;, &#39;filter_where&#39;);</code> after the query. </p> http://wordpress.org/support/topic/334105#post-1293220 Wed, 25 Nov 2009 11:58:10 +0000 gbaka 1293220@http://wordpress.org/support/ <p>this seems to only show updated post that are still on the frontpage and doesn't show any updated post that aren't on the front page. </p> http://wordpress.org/support/topic/335288#post-1292841 Wed, 25 Nov 2009 01:05:09 +0000 MichaelH 1292841@http://wordpress.org/support/ <p>Or use <a href="http://wordpress.org/extend/plugins/search-and-replace/" rel="nofollow">http://wordpress.org/extend/plugins/search-and-replace/</a> </p> http://wordpress.org/support/topic/335288#post-1292677 Tue, 24 Nov 2009 22:07:44 +0000 SS_Minnow 1292677@http://wordpress.org/support/ <p>It has come up for me recently that I have to change every occurrence of a client's company name or acronym. I don't know if it's possible but it would be great if WP had a Search &amp; Replace feature, perhaps with options like "this post or page only", "all posts", "all pages", "all posts and pages".</p> <p>I was able to find them all w/ WPs search feature, which helped, but I had to change them all one by one, which took a lot of time.</p> <p>In the meantime, I'm going to look into doing this w/ MySQL.</p> <p>Thanks! </p> http://wordpress.org/support/topic/334105#post-1291111 Mon, 23 Nov 2009 16:11:01 +0000 MichaelH 1291111@http://wordpress.org/support/ <p>That would be true. To make pagination work, you'd have to do something like this:<br /> <pre><code>&lt;?php function filter_where($where = &#39;&#39;) { $where .= &quot; AND post_date != post_modified &quot;; return $where; } add_filter(&#39;posts_where&#39;, &#39;filter_where&#39;); query_posts($query_string); ?&gt;</code></pre> <p>Didn't test this though. May need a remove_filter also. </p> http://wordpress.org/support/topic/288774#post-1290376 Sun, 22 Nov 2009 22:03:30 +0000 riri23 1290376@http://wordpress.org/support/ <p>Nice code, do you have a way to display result on two colums? </p> http://wordpress.org/support/topic/334105#post-1290140 Sun, 22 Nov 2009 16:54:49 +0000 gbaka 1290140@http://wordpress.org/support/ <p>well it works for the most part except i can't control the amount of post that show up in the page because it seems to be counting non editted post as well any to control that show ignores the noneditted post from the post count? </p> http://wordpress.org/support/topic/334105#post-1289143 Sat, 21 Nov 2009 14:05:16 +0000 MichaelH 1289143@http://wordpress.org/support/ <p>Something like this in a 'normal' <a href="http://codex.wordpress.org/The_Loop">loop</a>:<br /> <pre><code>if ($post-&gt;post_date != $post-&gt;post_modified) { //display your modified posts }</code></pre> <p>[edit] </p> http://wordpress.org/support/topic/334105#post-1289131 Sat, 21 Nov 2009 13:46:50 +0000 gbaka 1289131@http://wordpress.org/support/ <p>I'm using the query_post modified code to display modified post I'm just wondering is there a way to ignore or hide unmodified post? </p> http://wordpress.org/support/topic/288774#post-1289038 Sat, 21 Nov 2009 09:35:07 +0000 styzer 1289038@http://wordpress.org/support/ <p>This sounds like what I need...</p> <p>I use a template called Arclite 2.02, on WP 2.8.6.</p> <p>I am creating a website that would give artists their own page, and blog, with a media player for their music. I want the artists pages to automatically be ordered alphabetically for search and browsing convenience. </p> <p>So far, I've not been able to visualize any of the process of creating a tag.php page or any other such codes/plugin. It would be great to find step by step instructions, I'm a bit limited in that area.</p> <p>I thought if I could tag pages (mydomain.com/lastname-firstname), then it could sort alphabetically. But tags seem to only apply to posts. Same with categories. </p> <p>I copy/pasted the code by design-dolphin and created a t-tag.php file. I uploaded it in my template folder via FTP. I went to create a page but could not find any "tags" template. </p> <p>What am I missing?</p> <p>Cheers!</p> <p>Andre</p> <p>p.s. The site is: <a href="http://www.soakingplanet.com" rel="nofollow">http://www.soakingplanet.com</a></p> <p>All content on the first page here is basically copy/pasted from another of my sites. I want this new site to be the artists site instead.</p> <p>If you look on the menu, my name is there. That would be an artist name, leading to an artist page. But that would make it impossible for a menu to make sense with over 50 artists. Help! </p> http://wordpress.org/support/topic/333582#post-1287632 Fri, 20 Nov 2009 01:56:25 +0000 freshifreshy 1287632@http://wordpress.org/support/ <blockquote><p>Can only guess might need to add wp_reset_query(); after your query loop.</p></blockquote> <p>That didn't work, but I realized that I had the Search Unleashed plugin activated. I deactivated it and now the search is working.</p> <p>Thanks for your help! </p> http://wordpress.org/support/topic/288774#post-1287411 Thu, 19 Nov 2009 22:18:43 +0000 design_dolphin 1287411@http://wordpress.org/support/ <p>My bad. Just noticed that in the previous code snippet I posted the following line has the variable $custom_taxonomy_parent which is not being used:</p> <pre><code>$list .= &#39;&lt;li class=&quot;cat-item&quot;&gt;&lt;a rel=&quot;nofollow&quot; title=&quot;&#39; . $name . &#39; folder&quot; href=&quot;&#39; . $custom_taxonomy_parent . $url . &#39;&quot;&gt;&#39; . $name . &#39;&lt;/a&gt;&lt;/li&gt;&#39;;</code></pre> <p>This is the corrected code snippet:</p> <pre><code>&lt;?php $list = &#39;&#39;; $tags = get_terms(&#39;your_custom_taxonomy&#39;); $groups = array(); if( $tags &amp;&amp; is_array( $tags ) ) { foreach( $tags as $tag ) { $first_letter = strtoupper( $tag-&gt;name[0] ); $groups[ $first_letter ][] = $tag; } if( !empty( $groups ) ) { { $index_row .=&#39;&lt;ul class=&quot;topindex&quot;&gt;&#39;; foreach ($groups as $letter =&gt; $tags) { $index_row .= &#39;&lt;li&gt;&lt;h4&gt;&lt;a rel=&quot;nofollow&quot; href=&quot;#&#39; . $letter . &#39;-folder&quot; title=&quot;&#39; . $letter . &#39; folder&quot;&gt;&#39; . apply_filters( &#39;the_title&#39;, $letter ) . &#39;&lt;/a&gt;&lt;/h4&gt;&lt;/li&gt;&#39;; } $index_row .=&#39;&lt;/ul&gt;&lt;br class=&quot;clear&quot;&gt;&#39;; } $list .= &#39;&lt;ul class=&quot;index&quot;&gt;&#39;; foreach( $groups as $letter =&gt; $tags ) { $list .= &#39;&lt;li&gt;&lt;a name=&quot;&#39; . $letter . &#39;-folder&quot;&gt;&lt;/a&gt;&lt;h5&gt;&lt;a rel=&quot;nofollow&quot; href=&quot;#tags_top&quot; title=&quot;Back to index&quot;&gt;&#39; . apply_filters( &#39;the_title&#39;, $letter ) . &#39;&lt;/a&gt;&lt;/h5&gt;&#39;; $list .= &#39;&lt;ul class=&quot;links&quot;&gt;&#39;; foreach( $tags as $tag ) { $url = attribute_escape(get_bloginfo(&#39;url&#39;) . &#39;/&#39; . $tag-&gt;taxonomy . &#39;/&#39; . $tag-&gt;slug); $name = apply_filters( &#39;the_title&#39;, $tag-&gt;name ); $list .= &#39;&lt;li class=&quot;cat-item&quot;&gt;&lt;a rel=&quot;nofollow&quot; title=&quot;&#39; . $name . &#39; folder&quot; href=&quot;&#39; . $url . &#39;&quot;&gt;&#39; . $name . &#39;&lt;/a&gt;&lt;/li&gt;&#39;; } $list .= &#39;&lt;/ul&gt;&lt;/li&gt;&#39;; } $list .= &#39;&lt;/ul&gt;&#39;; } } else $list .= &#39;&lt;p&gt;Sorry, but no tags were found&lt;/p&gt;&#39;; ?&gt; &lt;a name=&quot;tags_top&quot;&gt;&lt;/a&gt; &lt;?php print $index_row; ?&gt; &lt;?php print $list; ?&gt;</code></pre> <p>Please note that this is still a beta code snippet. </p> http://wordpress.org/support/topic/333582#post-1287405 Thu, 19 Nov 2009 22:11:38 +0000 MichaelH 1287405@http://wordpress.org/support/ <p>Can only guess might need to add <code>wp_reset_query();</code> after your query loop.</p> <p>If that doesn't work for you, please paste all the code from the theme template file that exhibits the problem into a pastebin such as <a href="http://wordpress.pastebin.ca">wordpress.pastebin.ca</a>, and report the link back here. Maybe someone can spot your problem. Thanks. </p> http://wordpress.org/support/topic/288774#post-1287377 Thu, 19 Nov 2009 21:38:57 +0000 tugbucket 1287377@http://wordpress.org/support/ <p><a href="http://wordpress.org/extend/plugins/multi-column-tag-map/" rel="nofollow">http://wordpress.org/extend/plugins/multi-column-tag-map/</a></p> <p>you might take a look at that as well. It might fit your needs. </p> http://wordpress.org/support/topic/288774#post-1287346 Thu, 19 Nov 2009 21:16:11 +0000 design_dolphin 1287346@http://wordpress.org/support/ <p>@hifa<br /> Thank you for pointing me to that new feature. :-) Looks great. Lots of potential.</p> <p>@mfields<br /> From what I can figure out you are correct. Although it should be possible to fill the custom taxonomy name in automatically, haven't figured that out, yet.</p> <p>In order to direct the tag link in the TOC (Table of Contents) to taxonomy.php I had to rewrite the code. Otherwise the link will link to the tag.php template. This means in theory that if you have two custom taxonomies with two tags with the same name they would point to the same url. </p> <p><strong>Code:</strong><br /> <pre><code>&lt;?php $list = &#39;&#39;; $tags = get_terms(&#39;your_custom_taxonomy&#39;); $groups = array(); if( $tags &amp;&amp; is_array( $tags ) ) { foreach( $tags as $tag ) { $first_letter = strtoupper( $tag-&gt;name[0] ); $groups[ $first_letter ][] = $tag; } if( !empty( $groups ) ) { { $index_row .=&#39;&lt;ul class=&quot;topindex&quot;&gt;&#39;; foreach ($groups as $letter =&gt; $tags) { $index_row .= &#39;&lt;li&gt;&lt;h4&gt;&lt;a rel=&quot;nofollow&quot; href=&quot;#&#39; . $letter . &#39;-folder&quot; title=&quot;&#39; . $letter . &#39; folder&quot;&gt;&#39; . apply_filters( &#39;the_title&#39;, $letter ) . &#39;&lt;/a&gt;&lt;/h4&gt;&lt;/li&gt;&#39;; } $index_row .=&#39;&lt;/ul&gt;&lt;br class=&quot;clear&quot;&gt;&#39;; } $list .= &#39;&lt;ul class=&quot;index&quot;&gt;&#39;; foreach( $groups as $letter =&gt; $tags ) { $list .= &#39;&lt;li&gt;&lt;a name=&quot;&#39; . $letter . &#39;-folder&quot;&gt;&lt;/a&gt;&lt;h5&gt;&lt;a rel=&quot;nofollow&quot; href=&quot;#tags_top&quot; title=&quot;Back to index&quot;&gt;&#39; . apply_filters( &#39;the_title&#39;, $letter ) . &#39;&lt;/a&gt;&lt;/h5&gt;&#39;; $list .= &#39;&lt;ul class=&quot;links&quot;&gt;&#39;; foreach( $tags as $tag ) { $url = attribute_escape(get_bloginfo(&#39;url&#39;) . &#39;/&#39; . $tag-&gt;taxonomy . &#39;/&#39; . $tag-&gt;slug); $name = apply_filters( &#39;the_title&#39;, $tag-&gt;name ); $list .= &#39;&lt;li class=&quot;cat-item&quot;&gt;&lt;a rel=&quot;nofollow&quot; title=&quot;&#39; . $name . &#39; folder&quot; href=&quot;&#39; . $custom_taxonomy_parent . $url . &#39;&quot;&gt;&#39; . $name . &#39;&lt;/a&gt;&lt;/li&gt;&#39;; } $list .= &#39;&lt;/ul&gt;&lt;/li&gt;&#39;; } $list .= &#39;&lt;/ul&gt;&#39;; } } else $list .= &#39;&lt;p&gt;Sorry, but no tags were found&lt;/p&gt;&#39;; ?&gt; &lt;a name=&quot;tags_top&quot;&gt;&lt;/a&gt; &lt;?php print $index_row; ?&gt; &lt;?php print $list; ?&gt;</code></pre> <p>Also ran the code since the previous code snippet through automatic WCAG 2.0 and section 507 tests. And the code passes. It should still pass, but please check to be sure. Improvements are definitely welcome</p> <p>This is a beta code snippet, as I am still trying to understand the whole custom taxonomies, so there might be better ways to do it. </p> http://wordpress.org/support/topic/333582#post-1287181 Thu, 19 Nov 2009 19:21:14 +0000 freshifreshy 1287181@http://wordpress.org/support/ <p>When I run a search on my site, the "recent posts" and other new WP_Query loops all display only posts related to my search terms.</p> <p>Essentially, the search term seems to override any other queries that I have going on.</p> <p>Any thoughts on what might be happening? </p> http://wordpress.org/support/topic/333504#post-1286995 Thu, 19 Nov 2009 16:41:29 +0000 MichaelH 1286995@http://wordpress.org/support/ <pre><code>&lt;?php $type=&#39;post&#39;; //or $type=&#39;page&#39; $args=array( &#39;post_type&#39; =&gt; $type, &#39;post__in&#39; =&gt; array(5,143,145), &#39;caller_get_posts&#39;=&gt;1 ); $my_query = new WP_Query($args); if( $my_query-&gt;have_posts() ) { echo &#39;List of &#39;. $type . &#39;(s)&#39;; while ($my_query-&gt;have_posts()) : $my_query-&gt;the_post(); ?&gt; &lt;p&gt; &lt;?php the_category(&#39;, &#39;); ?&gt; - &lt;a href=&quot;&lt;?php the_permalink() ?&gt;&quot; rel=&quot;bookmark&quot; title=&quot;Permanent Link to &lt;?php the_title_attribute(); ?&gt;&quot;&gt;&lt;?php the_title(); ?&gt;&lt;/a&gt;&lt;/p&gt; &lt;?php endwhile; } //if ($my_query) wp_reset_query(); // Restore global post data stomped by the_post(). ?&gt;</code></pre> http://wordpress.org/support/topic/333504#post-1286940 Thu, 19 Nov 2009 15:56:22 +0000 devaleur 1286940@http://wordpress.org/support/ <p>Hi<br /> Please there are someone who can tell me how can I select with query_posts() just the pages with ID 5, 143 and 145.<br /> Thanks.. </p> http://wordpress.org/support/topic/332377#post-1283480 Mon, 16 Nov 2009 19:28:14 +0000 boonesimpson 1283480@http://wordpress.org/support/ <p>Thanks, I had to modify it some, but it works.</p> <pre><code>&lt;?php $count = 0; $result = &#39;&#39;; $catposts = get_posts(&#39;cat=1&amp;&amp;numberposts=0&#39;); if ( $catposts ) { //if there are any posts foreach($catposts as $single): setup_postdata($single); $mylimit=1 * 86400; //days * seconds per day $post_age = date(&#39;U&#39;) - mysql2date(&#39;U&#39;, $single-&gt;post_date_gmt); if ($post_age &lt; $mylimit) { $count++; if ( $count &lt; 6 ) { // only process 5 $result .= &#39;&lt;li&gt;&lt;a href=&#39;; $result .=get_permalink($single-&gt;ID).&#39;&gt;&#39;.$single-&gt;post_title.&#39;&lt;/a&gt;&lt;/li&gt;&#39;; } } endforeach; if ($result ==&#39;&#39;){} else{ echo &quot;&lt;h2 id=&#39;latesth2&#39; class=&#39;sectionhead&#39;&gt;&lt;a href=&#39;/category/breaking/&#39;&gt;The Latest&lt;/a&gt;&lt;/h2&gt;&lt;ul&gt;&quot;; echo $result.&quot;&lt;/ul&gt;&quot;; } } ?&gt;</code></pre> http://wordpress.org/support/topic/332377#post-1283436 Mon, 16 Nov 2009 18:41:24 +0000 MichaelH 1283436@http://wordpress.org/support/ <p>Test for posts that are so many days old date (in this case 1 day)<br /> <pre><code>&lt;?php $mylimit=1 * 86400; //days * seconds per day //$post_age = date(&#39;U&#39;) - get_post_time(&#39;U&#39;); $post_age = date(&#39;U&#39;) - mysql2date(&#39;U&#39;, $post-&gt;post_date_gmt); if ($post_age &lt; $mylimit) { echo &#39;this post is within my date limit &#39;; } ?&gt;</code></pre> http://wordpress.org/support/topic/332377#post-1283380 Mon, 16 Nov 2009 17:50:59 +0000 boonesimpson 1283380@http://wordpress.org/support/ <p>I am working on a post query that shows posts made within the past 24 hours. I have one currently that compared against the date, but if a post is made at 23:00 hours, it dies in 1 hour.<br /> My current code is below:</p> <pre><code>&lt;?php $count = 0; $result = &#39;&#39;; $catposts = get_posts(&#39;cat=1&amp;&amp;numberposts=0&#39;); if ( $catposts ) { //if there are any posts foreach($catposts as $single): setup_postdata($single); $post_date = mysql2date(&quot;Ymd&quot;, $single-&gt;post_date); if ( $post_date == date(&#39;Ymd&#39;) ) { // if post is from today, display $count++; if ( $count &lt; 6 ) { // only process 5 $result .= &#39;&lt;li&gt;&lt;a href=&#39;; $result .=get_permalink($single-&gt;ID).&#39;&gt;&#39;.$single-&gt;post_title.&#39;&lt;/a&gt;&lt;/li&gt;&#39;; } } endforeach; if ($result ==&#39;&#39;){} else{ echo &quot;&lt;h2 id=&#39;latesth2&#39; class=&#39;sectionhead&#39;&gt;&lt;a href=&#39;/category/breaking/&#39;&gt;The Latest&lt;/a&gt;&lt;/h2&gt;&lt;ul&gt;&quot;; echo $result.&quot;&lt;/ul&gt;&quot;; } } ?&gt;</code></pre> <p>This has it where the section heading of "breaking" only shows when posts meet the requirement category and date / time requirement.</p> <p>Thanks </p> http://wordpress.org/support/topic/332116#post-1282506 Sun, 15 Nov 2009 23:56:02 +0000 newkind 1282506@http://wordpress.org/support/ <p>Hi,</p> <p>I'm using query_posts on my archive, category, tags etc. pages for controlling more parameters like number of displayed posts for different things. I noticed lately something weird. When for an example i set category page to show 1 post per page and go to the page 3 (sometimes 4 or 5) the query seems to crash. No posts are displayed, category title (or month - depends on what page I am) dissappear ... I tried to echo $query_string for debugging and for the first pages it displays everything fine but when query crashes it dissappears with everything else. Any ideas or similar issues ?</p> <p>I'm using standard loop :<br /> <pre><code>&lt;?php query_posts($query_string.&#39;&amp;posts_per_page=&#39;.$archive_postnum.&#39;&amp;paged=&#39;.$paged); ?&gt; &lt;?php if (have_posts()) : ?&gt;</code></pre> <p>Thanks</p> <p>P.S this happens on all wordpress versions including 2.8.6 </p> http://wordpress.org/support/topic/326520#post-1282437 Sun, 15 Nov 2009 22:56:58 +0000 katmassive 1282437@http://wordpress.org/support/ <p>Never mind used this instead...<br /> <a href="http://wordpress.org/support/topic/306790" rel="nofollow">http://wordpress.org/support/topic/306790</a></p> <p>Just in case anyones tryna do the same thing ... </p> http://wordpress.org/support/topic/326520#post-1282021 Sun, 15 Nov 2009 12:50:01 +0000 katmassive 1282021@http://wordpress.org/support/ <p>k one minor hiccup how do i get it to show the loop a minimum of 4 times...</p> <p>thanks in advance. </p> http://wordpress.org/support/topic/326520#post-1281984 Sun, 15 Nov 2009 11:09:30 +0000 katmassive 1281984@http://wordpress.org/support/ <p>Thanks guys this helped me alot after hours of tryna get it done myself. </p> http://wordpress.org/support/topic/331159#post-1279331 Thu, 12 Nov 2009 22:39:23 +0000 cinemadiving 1279331@http://wordpress.org/support/ <p>Hi MichaelH</p> <p>You're a star! Thanks so much for your help ... I really appreciate it.</p> <p>Cheers,<br /> Gregg </p> http://wordpress.org/support/topic/331159#post-1279281 Thu, 12 Nov 2009 22:04:02 +0000 MichaelH 1279281@http://wordpress.org/support/ <p>For the section beginning with endwhle, ending with wp_reset_query try:</p> <pre><code>&lt;?php endwhile; } else { &lt;p class=&quot;no-data&quot;&gt;&lt;?php _e(&#39;Sorry, no posts matched your criteria.&#39;, &#39;hybrid&#39;); ?&gt;&lt;/p&gt; &lt;?php } ?&gt; wp_reset_query(); // Restore global post data stomped by the_post(). ?&gt;</code></pre>