get_results(" SELECT * from $table_name
WHERE date_finished = '0000:00:00' AND date_started != '0000:00:00'
UNION
SELECT * from $table_name
WHERE date_finished != '0000:00:00'
ORDER BY date_started DESC, date_finished DESC
");
if (!empty($results))
{
?>
Readings:isbn . AMAZON_LINK_SUFFIX;
?>
title ?>author ?>
date_started != '0000-00-00') {
?>
Started:date_started; ?>
date_finished != '0000-00-00') {
?>
Finished:date_finished; ?>
get_row("SELECT * FROM $table_name WHERE date_finished = '0000-00-00' ORDER BY date_started DESC LIMIT 1");
if (empty($row))
{
$row = $wpdb->get_row("SELECT * FROM $table_name ORDER BY date_started DESC, date_finished DESC LIMIT 1");
}
$link = AMAZON_LINK_PREFIX . $row->isbn . AMAZON_LINK_SUFFIX;
extract($args);
echo $before_widget . $before_title . 'Current Reading' . $after_title;
echo '
';
?>
title ?>author ?>
';
echo $after_widget;
}
register_sidebar_widget('Current Reading', 'widget_bookshelf');
}
add_action('plugins_loaded', 'widget_bookshelf_init');
?>