<!---
Name:        ratings.cfm
Author:      David Golden (d_golden73@hotmail.com)
Description: Ratings List
Created:     4/15/01
--->

<!--- Get ratings list from database --->
<CFQUERY NAME="GetRatings" DATASOURCE="ows">
  SELECT Rating, Count(*) AS FilmCount
  FROM FilmsRatings, Films
  WHERE FilmsRatings.RatingID = Films.RatingID
  GROUP BY Rating
  ORDER BY Rating
</CFQUERY>


<!--- Create HTML page --->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
    <TITLE>Orange Whip Studios - Ratings List</TITLE>
</HEAD>

<BODY>

<H1>Ratings List</H1>

<!--- Display ratings --->
<TABLE BORDER="1">
<TR>
 <TH>Rating Category</TH>
 <TH>Movies</TH>
</TR>
<CFOUTPUT QUERY="GetRatings">
<TR> 
 <TD>#GetRatings.Rating#</TD>
 <TD>#GetRatings.FilmCount#</TD>
</TR>
</CFOUTPUT>
</TABLE>

</BODY>
</HTML>
