I want to display my second last uploaded product and i need help in writing a query to grab it from the database. i could do it for the last uploaded product using the following code:
<?php
$args = array(
'post_type' => 'product',
'stock' => 1,
'posts_per_page' => 1,
'orderby' =>'date',
'order' => 'DESC',
'product_cat' => 'books' );
$loop = new WP_Query( $args );
while ( $loop->have_posts() ) : $loop->the_post(); global $product; ?>
<div class="span3">
<a id="id-<?php the_id(); ?>" href="<?php the_permalink(); ?>" title="<?php the_title(); ?>">
<?php if (has_post_thumbnail( $loop->post->ID )) echo get_the_post_thumbnail($loop->post->ID, 'shop_catalog'); else echo '<img src="'.woocommerce_placeholder_img_src().'" alt="My Image Placeholder" width="65px" height="115px" />'; ?>
<h3><?php the_title(); ?></h3>
<span class="price"><?php echo $product->get_price_html(); ?></span>
</a>
<?php woocommerce_template_loop_add_to_cart( $loop->post, $product ); ?>
</div>
<?php endwhile; ?>
<?php wp_reset_query(); ?>
But if i want to display only the second last element then how can i achieve it?
