The Carp 500
include 'include/carpdb.php';
$results = $carpdb->get_results(“SELECT b.bookID as id, b.title as title, b.author as author FROM `books` b, `listdata` l WHERE l.listid=’52′ AND b.bookID=l.mediaID AND l.mediatypeid = ‘books’ ORDER BY author, title”);
$count = 1;
echo “
- “;
- $result->author — id\”>$result->title
foreach($results as $result)
{
echo “
“;
$count++;
}
echo “
“;
?>