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