Forum

<div id="sermon-search" class="widget sidebar-block sermon-search"><h3 class="widgettitle">Search Sermons</h3>
<?php
// Drop-down filter
$preachers = $wpdb->get_results("SELECT p.*, count(p.id) AS count FROM {$wpdb->prefix}sb_preachers AS p JOIN {$wpdb->prefix}sb_sermons AS s ON p.id = s.preacher_id GROUP BY p.id ORDER BY count DESC, s.datetime DESC");
$series = $wpdb->get_results("SELECT ss.*, count(ss.id) AS count FROM {$wpdb->prefix}sb_series AS ss JOIN {$wpdb->prefix}sb_sermons AS sermons ON ss.id = sermons.series_id GROUP BY ss.id ORDER BY sermons.datetime DESC");
$services = $wpdb->get_results("SELECT s.*, count(s.id) AS count FROM {$wpdb->prefix}sb_services AS s JOIN {$wpdb->prefix}sb_sermons AS sermons ON s.id = sermons.service_id GROUP BY s.id ORDER BY count DESC");
$book_count = $wpdb->get_results("SELECT bs.book_name AS name, count(distinct bs.sermon_id) AS count FROM {$wpdb->prefix}sb_books_sermons AS bs JOIN {$wpdb->prefix}sb_books AS b ON bs.book_name = b.name GROUP BY b.id");
$sb = array(
'Title' => 'm.title',
'Preacher' => 'preacher',
'Date' => 'm.datetime',
'Passage' => 'b.id',
);
$di = array(
'Ascending' => 'asc',
'Descending' => 'desc',
);
$csb = isset($_REQUEST['sortby']) ? $_REQUEST['sortby'] : 'm.datetime';
$cd = isset($_REQUEST['dir']) ? $_REQUEST['dir'] : 'desc';
?>
<span class="inline_controls"><a href="#" id="show_hide_filter"></a></span>
<div id="mainfilter">
<form method="post" id="sermon-filter" action="<?php echo sb_display_url(); ?>">
<div style="clear:both">
<table class="sermon-search">
<tr>
<td class="fieldname"><?php _e('Preacher', $sermon_domain) ?></td>
<td class="field"><select name="preacher" id="preacher">
<option value="0" <?php echo (isset($_REQUEST['preacher']) && $_REQUEST['preacher'] != 0) ? '' : 'selected="selected"' ?>><?php _e('[All]', $sermon_domain) ?></option>
<?php foreach ($preachers as $preacher): ?>
<option value="<?php echo $preacher->id ?>" <?php echo isset($_REQUEST['preacher']) && $_REQUEST['preacher'] == $preacher->id ? 'selected="selected"' : '' ?>><?php echo stripslashes($preacher->name).' ('.$preacher->count.')' ?></option>
<?php endforeach ?>
</select>
</td>
</tr>
<tr>
<td class="fieldname"><?php _e('Book', $sermon_domain) ?></td>
<td class="field"><select name="book">
<option value=""><?php _e('[All]', $sermon_domain) ?></option>
<?php foreach ($book_count as $book): ?>
<option value="<?php echo $book->name ?>" <?php echo isset($_REQUEST['book']) && $_REQUEST['book'] == $book->name ? 'selected=selected' : '' ?>><?php echo stripslashes($book->name). ' ('.$book->count.')' ?></option>
<?php endforeach ?>
</select>
</td>
</tr>
<tr>
<td class="fieldname"><?php _e('Series', $sermon_domain) ?></td>
<td class="field"><select name="series" id="series">
<option value="0" <?php echo (isset($_REQUEST['series']) && $_REQUEST['series'] != 0) ? '' : 'selected="selected"' ?>><?php _e('[All]', $sermon_domain) ?></option>
<?php foreach ($series as $item): ?>
<option value="<?php echo $item->id ?>" <?php echo isset($_REQUEST['series']) && $_REQUEST['series'] == $item->id ? 'selected="selected"' : '' ?>><?php echo stripslashes($item->name).' ('.$item->count.')' ?></option>
<?php endforeach ?>
</select>
</td>
</tr>
<tr>
<td class="fieldname"><?php _e('Keywords', $sermon_domain) ?></td>
<td class="field" colspan="3"><input style="width: 50%" type="text" id="title" name="title" value="<?php echo isset($_REQUEST['title']) ? mysql_real_escape_string($_REQUEST['title']) : '' ?>" /></td>
</tr>
<tr>
<td colspan="1"></td>
<td class="field"><input type="submit" class="filter" value="<?php _e('Search', $sermon_domain) ?>"></td>
</tr>
</table>
<input type="hidden" name="page" value="1">
</div>
</form>
</div>
<script type="text/javascript">
jQuery.datePicker.setDateFormat('ymd','-');
jQuery('#date').datePicker({startDate:'01/01/1970'});
jQuery('#enddate').datePicker({startDate:'01/01/1970'});
<?php if ($hide_filter === TRUE) { ?>
jQuery(document).ready(function() {
<?php echo $js_hide; ?>
});
<?php } ?>
</script>

</div>
</div>