<?php
  //connect to MySQL
  $connect\; =\; mysql\_connect("localhost",\; "bp5am",\; "bp5ampass")\; or\; die\; ("Hey\; loser,\; check\; your\; server\; connection.");\; mysql\_select\_db("moviesite");$//create "reviews" table
  reviews = "CREATE TABLE reviews (
    review_movie_id int(11) NOT NULL, 
    review_date date NOT NULL, 
    review_name varchar(255) NOT NULL, 
    review_reviewer_name varchar(255) NOT NULL, 
    review_comment varchar(255) NOT NULL, 
    review_rating int(11) NOT NULL default 0, 
    KEY (review_movie_id)
  )";
  
  $results\; =\; mysql\_query($reviews)
    or die (mysql_error());
  
  //populate the "reviews" table
  $insert\; =\; "INSERT\; INTO\; reviews\; (review\_movie\_id,\; review\_date,\; review\_name,\; review\_reviewer\_name,\; review\_comment,\; review\_rating)\; VALUES\; (\text{'}1\text{'},\; \text{'}2003-08-02\text{'},\; \text{'}This\; movie\; rocks!\text{'},\; \text{'}John\; Doe\text{'},\text{'}I\; thought\; this\; was\; a\; great\; movie\; even\; though\; my\; girlfriend\; made\; me\; see\; it\; against\; my\; will.\text{'}\; ,\text{'}4\text{'}),\; (\text{'}1\text{'},\text{'}2003-08-01\text{'},\text{'}An\; okay\; movie\text{'},\; \text{'}Billy\; Bob\text{'},\text{'}This\; was\; an\; okay\; movie.\; I\; liked\; Eraserhead\; better.\text{'},\text{'}2\text{'}),\; (\text{'}1\text{'},\text{'}2003-08-10\text{'},\text{'}Woo\; hoo!\text{'},\; \text{'}Peppermint\; Patty\text{'},\text{'}Wish\; I\backslash \text{'}d\; have\; seen\; it\; sooner!\text{'},\text{'}5\text{'}),\; (\text{'}2\text{'},\text{'}2003-08-01\text{'},\text{'}My\; favorite\; movie\text{'},\; \text{'}Marvin\; Marian\text{'},\text{'}I\; didn\backslash \text{'}t\; wear\; my\; flair\; to\; the\; movie\; but\; I\; loved\; it\; anyway.\text{'},\text{'}5\text{'}),\; (\text{'}3\text{'},\text{'}2003-08-01\text{'},\text{'}An\; awesome\; time\text{'},\; \text{'}George\; B.\text{'},\text{'}I\; liked\; this\; movie,\; even\; though\; I\; thought\; it\; was\; an\; informational\; video\; from\; our\; travel\; agent.\text{'},\text{'}3\text{'})";$insert_results = mysql_query($insert)\; or\; die(mysql\_error());\; ?>$