[RESOLVED] INNER JOIN Query Issue

[gobbles]

Hey All,

Does anybody see any problems with this couple of lines of code below.

  $id = $_GET['id'];

  $page_query = "SELECT packages.id, packages.price, advertisers.venue_name, advertisers.signup_date, advertisers.paid, advertisers.plan, advertisers.id
                 FROM packages
                 INNER JOIN advertisers
                 ON advertisers.plan = packages.id
                 WHERE advertisers.id = '$id'";
  $page_result = mysql_query($page_query) or die("Error: " . mysql_error());
  $pagerow = mysql_fetch_array($page_results);

When i type <?php echo $pagerow['venue_name']; ?> nothing is appearing.

[gobbles]

Well ill be damned ... I missed the 's' on the $page_result

My bad.