StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODisplay a custom Wordpress taxonomy tag automatically based on the day of the week?
primarykey
Id
15378274
data
AcceptedAnswerId
15378525
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-03-13T06:14:02.617
FavoriteCount
0
LastActivityDate
2013-03-13T16:23:27.593
LastEditDate
2013-03-13T16:13:21.863
LastEditorUserId
1767076
OwnerUserId
1767076
ParentId
0
PostTypeId
1
Score
1
ViewCount
266
LastEditorDisplayName
text
Body
<p>I've got a client that wants to display custom taxonomy tags automatically by day of the week in Wordpress. Basically, we'll have a custom post type called "products" and that will have a taxonomy called "day." Within "day" we'll have seven tags, one for each day of the week, and anything tagged with a specific day of the week will display on that day on the home page.</p> <p>So, for example, if Product A, B & C are all assigned a tag of "Wednesday" within the taxonomy "day" and today is Wednesday, then those items will display on the home page. If products D, E & F are assigned Thursday, they'll show up on Thursday, and so on.</p> <p>With all that said, the part I need help with is writing a loop that can detect the day of the week and then query the proper taxonomy tag. Does anyone have any idea how to go about this? I really can't find any reference on this and my PHP skills are rudimentary at best. :-/</p> <p>Here's the loop I'm currently using to display products manually by custom post type, taxonomy & term:</p> <pre><code><?php query_posts('post_type=products&taxonomy=day&term=wednesday&posts_per_page=10'); ?> <?php if(have_posts()) : while (have_posts() ) : the_post(); ?> <div class="archivecustompost"> <div class="archivecustomleftblock"> <a href="<?php the_permalink() ?>" rel="bookmark"><?php the_post_thumbnail( array(150,150) ); ?></a> </div> <div class="archivecustomrightblock"> <h2><?php the_title(); ?></h2> <?php the_excerpt(); ?> <p class="button"><a href="<?php the_permalink() ?>" rel="bookmark">Learn More</a></p> </div> </div> <?php endwhile; endif; ?> </code></pre>
Tags
<php><wordpress>
Title
Display a custom Wordpress taxonomy tag automatically based on the day of the week?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJoey the Squid
UserOwnerUserId
1. USJoey the Squid
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PODisplay a custom Wordpress taxonomy tag automatically based on the day of the week?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.