868Part VCase StudiesListing 45-5(continued) group by quotations.idorder by avg_rank desc limit 10 ; $result = $db->query($query_best); if (DB::isError($result)) { $errorMessage = $result->getMessage(); die ($errorMessage); } $table_rows_string =
| Quote | Attribution | Average rating |
|---|
; while ($row_array = $result->fetchRow()) { $quotation_id = $row_array[ ID ]; $quotation_text = $row_array[ quotation ]; $truncated_quotation = truncate_quotation($quotation_text); $quotation_attribution = $row_array[ attribution ]; $avg_rank = $row_array[ avg_rank ]; $rounded_avg_rank = sprintf( %.1f , $avg_rank); $table_rows_string .=
| $truncated_quotation | $quotation_attribution | . $rounded_avg_rank |
; } $db->disconnect(); // lay out the page$title = Ratings page for quotes ; $page_string = <<
$title
Top ten most popular quotes
$table_rows_string