1840-1849

<<< 1830-1839

1850-1859 >>>

[php] global $wpdb;
$results = $wpdb->get_results(”
SELECT *
FROM $wpdb->posts
LEFT JOIN (
wp_term_taxonomy,
wp_terms,
wp_term_relationships
)
ON (
tmpae2a43_posts.ID=wp_term_relationships.object_id AND
wp_term_taxonomy.term_taxonomy_id=wp_term_relationships.term_taxonomy_id AND
wp_terms.term_id=wp_term_taxonomy.term_id
)
WHERE wp_term_taxonomy.taxonomy=’Aarstal’
AND tmpae2a43_posts.post_type=’koegebasen’
AND name BETWEEN 1840 and 1849 ORDER BY name;
“, ARRAY_A);

foreach($results as $row)
{
echo ‘[h2]’ . $row[‘name’] . ‘ ‘ . $row[‘post_title’] . ‘[/h2]’;
echo $row[‘post_content’] . ‘[/p]’;
}
[/php]

<<< 1830-1839

1850-1859 >>>