I checked my theme, and that other plugin isn’t a plugin, I think, it’s just code you gave me (reprinted below). It gives me the results properly sorted-by-custom-field-value (All the songs by Ben, then all the songs by Everyone, then Josh, then Trevor), but the post-titles within each custom-field-value are sorted chronologically, and I want alphabetically (All of Ben’s songs from A-Z, then all of Everyone’s A to Z, etc).
Example of the output,
Index of Songs sorted by lead vocalist
* Ben C – Planet
* Ben – Addressing The Community
* Everyone – Panspermic
* Everyone – Mosquito
* Josh Clark – Hot Dog
* Josh Clark – Carter Hotel
* Trevor – Farm’s Been Sold
* Trevor – Watching Anna Fall
* Trevor – Long Way to Texas
* Trevor – Forgiven
Here’s the code I use now,
<h3>Index of Songs sorted singer</h3>
<ul>
<?php
if ( $recentposts =
$wpdb->get_results("SELECT ID, post_title, post_date, meta_value, guid FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id WHERE post_status = 'publish' AND meta_key='Lead singer' ORDER BY meta_value, post_title DESC")) {
foreach ($recentposts as $post) {
echo "<li>{$post->meta_value} - <a href="/green/?p={$post->ID}" title="{$post->post_title}">{$post->post_title}</a></li><hr>
";} } ?>
</ul>
<h3>Index of Songs sorted by Album</h3>
<ul>
<?php
if ( $recentposts =
$wpdb->get_results("SELECT ID, post_title, post_date, meta_value, guid FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id WHERE post_status = 'publish' AND meta_key='On CD' ORDER BY meta_value, post_title DESC")) {
foreach ($recentposts as $post) {
echo "<li>{$post->meta_value} - <a href="/green/?p={$post->ID}" title="{$post->post_title}">{$post->post_title}</a></li><hr>
";} } ?>
</ul>
You also gave me the plugin for alphabetical Page Navigation, which works perfectly. I guess that’s the one you indicated could be combined to select by custom-field, which would also be handy.
I guess my top need is to fix the sub-alphabetization on the above code; second goal is the page nav idea stemming from this thread. You’re very kind to be so helpful.
