1990 ORDER BY movie_type"; $results=mysql_query($query) or die(mysql_error()); echo "\n"; while ($rows=mysql_fetch_assoc($results)) { echo "\n"; foreach($rows as $value) { echo "\n"; } echo "
\n"; } echo "

\n"; echo $value; echo "

\n"; ?>