StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWordpress: extract & resize post attachment
primarykey
Id
6934105
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-08-03T22:33:42.707
FavoriteCount
0
LastActivityDate
2011-10-30T01:21:27.623
LastEditDate
2011-08-03T23:25:17.870
LastEditorUserId
577826
OwnerUserId
577826
ParentId
0
PostTypeId
1
Score
0
ViewCount
796
LastEditorDisplayName
text
Body
<p>I know this question belongs in the wordpress forum, but I've posted about a half dozen questions there and have never gotten any responses - I like the community here much more, please don't move this question to wordpress. </p> <p>I'm looking for a way to extract the attachment (could be a photo, youtube vid, or soundcloud song) of a category's most recent post, resize it, and then display it on my homepage. Check out my site at <a href="http://beachief.com/" rel="nofollow">http://beachief.com/</a> to see what I mean - the "Daily Chief" and "Tribal Music" sections are where I want to do this. I successfully resized the images above those two sections with this code: </p> <pre><code><img src="<?php bloginfo('template_url'); ?>/images/philadelphia.jpg" alt="Featured picture" class="scaled"/> </code></pre> <p>But that only works for images that I have an exact file location to. This is the code I'm using to get my most recent posts and display some of their contents: </p> <pre><code><ul class="link-item"> <?php $feature_post = get_posts( 'category=4&numberposts=1' ); ?> <?php foreach( $feature_post as $post ) : setup_postdata( $post ); ?> <li><h2 class="link-item"><?php the_category(' '); ?></h2></li> <?php endforeach; ?> <?php $feature_post = get_posts( 'category=4&numberposts=1' ); ?> <?php foreach( $feature_post as $post ) : setup_postdata( $post ); ?> <li class="list-time"><?php the_time('d'); ?>.<?php the_time('M'); ?></li> <li class="list-title"><a href="<?php the_permalink() ?>" rel="bookmark"><?php the_title(); ?></a></li> <li class="link-item"><?php the_excerpt(); ?></li> <?php endforeach; ?> </ul> </code></pre> <p>I want to get rid of the excerpt and display the posts attachment, resized to match the columns width. How can I do this? Thanks</p>
Tags
<php><wordpress><customization>
Title
Wordpress: extract & resize post attachment
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCbas
UserOwnerUserId
1. USCbas
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. This table or related slice is empty.
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.