<?php
/*
Template Name: page-progetti-architecture
*/
?>
<?php $ordine= $_GET['ordine'];?>
<?php get_header(); ?>
<div class="grid_13" id="sezione">
<?php
$querystr =
"SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'Categoria'
AND wpostmeta.meta_value = 'Architecture'
AND wposts.post_type = 'page'
ORDER BY wpostmeta.meta_value DESC";
$pageposts = $wpdb->get_results($querystr, OBJECT);
?>
<?php
$sort= $_GET['ordine'];
if($sort == "data"){
$querystr =
"SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'Categoria'
AND wpostmeta.meta_value = 'Architecture'
AND wposts.post_type = 'page'
ORDER BY wpostmeta.meta_value DESC";
$pageposts = $wpdb->get_results($querystr, OBJECT);
}
if($sort == "alfabeto"){
$querystr =
"SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'Categoria'
AND wpostmeta.meta_value = 'Architecture'
AND wposts.post_type = 'page'
ORDER BY wpostmeta.meta_value DESC";
$pageposts = $wpdb->get_results($querystr, OBJECT);
}
?>
<div id="bread-and-ord">
<?php breadcrumb_trail( array( 'show_home' => false, 'before' => '', 'separator' => '»',) ); ?>
<br />
Ordina per:
<a href="?ordine=data">Data</a> - <a href="?ordine=alfabeto">Alfabeto</a>
<br />
</div>
<?php if ($pageposts): ?>
<?php global $post; ?>
<?php foreach ($pageposts as $post): ?>
<?php setup_postdata($post);
// check for thumbnail
$thumb = get_post_meta($post->ID, 'Thumbnail', $single = true);
// check for thumbnail class
$thumb_class = get_post_meta($post->ID, 'Thumbnail Class', $single = true);
// check for thumbnail alt text
$thumb_alt = get_post_meta($post->ID, 'Thumbnail Alt', $single = true);
?>
<div class="post sezione-box" id="post-<?php the_ID(); ?>">
<?php // if there's a thumbnail
if($thumb !== '') {
?>
<a href="<?php the_permalink() ?>">
<img
src="<?php echo $thumb; ?>"
class="<?php if($thumb_class !== '') { echo $thumb_class; } else { echo "left"; } ?>"
alt="<?php if($thumb_alt !== '') { echo $thumb_alt; } else { echo the_title(); } ?>"
/>
<p><?php the_title(); ?></p>
</a>
<?php
} // end if statement
// if there's not a thumbnail
else { echo ''; }
?>
</div>
<?php endforeach; ?>
<?php else : ?>
<h2 class="center">
Not Found
</h2>
<p class="center">
Sorry, but you are looking for something that isn't here.
</p>
<?php endif; ?>
</div>
<?php get_sidebar(); ?>
<?php get_footer(); ?>