StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWordpress: Include custom_fields (Book author) in search results
primarykey
Id
13466951
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-11-20T05:10:26.017
FavoriteCount
0
LastActivityDate
2012-11-20T06:29:38.120
LastEditDate
2012-11-20T06:29:38.120
LastEditorUserId
799774
OwnerUserId
799774
ParentId
0
PostTypeId
1
Score
0
ViewCount
458
LastEditorDisplayName
text
Body
<p>I am using TwentyEleven as my base theme which I have skinned. In my Content.php file, the search results looks something like this </p> <pre><code><?php if ( is_search() ) : // Only display Excerpts for Search ?> <div class="entry-summary"> <?php the_excerpt(); ?> </div> <?php else : ?> <div class="entry-content"> <?php the_content( __( 'Continue reading <span class="meta-nav">&rarr;</span>', 'twentyeleven' ) ); ?> <?php wp_link_pages( array( 'before' => '<div class="page-link"><span>' . __( 'Pages:', 'twentyeleven' ) . '</span>', 'after' => '</div>' ) ); ?> </div> <?php endif; ?> </code></pre> <p>I am trying to pull the "Author" Meta key/value pairs to return in my search results along with the Post Title and Post Content like so:</p> <pre><code><?php if ( is_search() ) : // Only display Excerpts for Search ?> <div class="entry-summary"> <?php the_excerpt(); ?> </div> <?php else : ?> <div class="entry-content"> <?php the_content( __( 'Continue reading <span class="meta-nav">&rarr;</span>', 'twentyeleven' ) ); ?> <?php get_post_meta(get_the_ID(), _wpsc_author, true); ?> <?php wp_link_pages( array( 'before' => '<div class="page-link"><span>' . __( 'Pages:', 'twentyeleven' ) . '</span>', 'after' => '</div>' ) ); ?> </div> <?php endif; ?> </code></pre> <p>Note the line: </p> <pre><code><?php get_post_meta(get_the_ID(), _wpsc_author, true); ?> </code></pre> <p>Yet, this returns nothing?</p> <p>I have read a fair amount on the topic of the_meta(), get_post_custom() etc, but nothing I am trying seems to have worked.</p> <p>Would appreciate some insight?</p> <p><strong>EDIT:</strong> Apologies, I wasn't too clear about the "Author" part. Author is a custom field in the post_meta table along with "book type", book condition" published year" etc. It is not the Post Author.</p> <p>Thanks</p>
Tags
<wordpress>
Title
Wordpress: Include custom_fields (Book author) in search results
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSixfootJames
UserOwnerUserId
1. USSixfootJames
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
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COAlso try print_r( get_post_custom() ); We're wanting to see if _wpsc_author is actually in your meta. Also.. this code looks like it's in the loop, we're in the loop right?
  singulars
  PostPostId
  POWordpress: Include custom_fields (Book author) in search results
  UserUserId
  USShawn Wernig
2. COIt seems like you're only pulling the author meta on non-search pages. That's a bit confusing as to whether that's exactly what you want, since you say that you want to display that information in the search results. Consider moving the `<?php echo (get_post_meta(get_the_ID(), _wpsc_author, true)); ?>` part after `<?php the_excerpt(); ?>`
  singulars
  PostPostId
  POWordpress: Include custom_fields (Book author) in search results
  UserUserId
  USNikola Ivanov Nikolov

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.