<?php
  //connect to MySQL
  $connect\; =\; mysql\_connect("localhost",\; "bp5am",\; "bp5ampass")\; or\; die\; ("Hey\; loser,\; check\; your\; server\; connection.");$//make sure we're using the right database
  mysql_select_db("moviesite");
  
  query = "SELECT movie.movie_name, movietype.movietype_label " .
           "FROM movie, movietype " .
           "WHERE movie.movie_type = movietype.movietype_id " .
           "AND movie.movie_year>1990 " .
           "ORDER BY movie_type";
  $results\; =\; mysql\_query($query)
    or die(mysql_error());
  
  echo "<table border=\"1\">\n";
  while ($row\; =\; mysql\_fetch\_assoc($results)) {
    echo "<tr>\n";
    foreach($row\; as$value) {
      echo "<td>\n";
      echo $value;\; echo\; "$</td>\n";
    }
    echo "</tr>\n";
  }
  echo "</table>\n";
  ?>