1990 " . "ORDER BY movie_type"; $results = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($results)) { extract($row); echo $movie_name; echo " - "; echo $movie_type; echo "
"; } ?>