[RESOLVED] Having trouble pulling data from two different tables into one query

[Twilite_Kid_82]

Hey, i've set up a page for when a band has shows it will display all the shows on a page.. All of the shows are displayed on the page but the field for address is not displaying.. I believe it is located in one table and the rest of the information such as city, state, country are in another, but they display properly... i'll link the page itself as an example and put the code below

Code:

<?php

$page_title = "SHOWS";

require("header.php");

?>



<p align="justify" class="style1 style4">SHOWS</p>



<?



if ($show) {



$sql = "SELECT DATE_FORMAT(date,'%c/%e/%Y'), venue_id, description FROM site_tourdates";

$result = mysql_query($sql,$dbh);

$err = mysql_error();



if (mysql_num_rows($result) > 0) {


if ($err) { echo "$err"; die; }

list($date, $venue_id, $description) = mysql_fetch_array($result);



$sql2 = "SELECT name, street_address, city, state, zipcode, country, age_restriction, phone_number, more_info FROM site_tourdates_venues WHERE id=$venue_id LIMIT 1";



$result2 = mysql_query($sql2,$dbh);

$err = mysql_error();

if ($err) { echo "$err"; die; }

list($venue_name, $street_address, $city, $state, $zipcode, $country, $age_restriction, $phone_number, $more_info ) = mysql_fetch_array($result2);



echo "When: $date <br> Where: $venue_name <br> Details: $description <br>&nbsp;<br>";



echo "<u>Venue Details <br>&nbsp;<br> $venue_name<br>&nbsp;<br>Address:<br>$street_address<br>$city, $state &nbsp; $zipcode<br>
";

echo "<b><a href=\"http://maps.google.com/maps?q=$street_address+$city,+$state,+$zipcode\" target=\"_blank\">
<u>View Map</u></b> </a> <br> 

";



if ($country != 'US') echo "$country<br>";



if (!$phone_number) $phone_number="N/A";

echo "&nbsp;<br>Phone Number: $phone_number<br>&nbsp;<br>";



if ($age_restriction) echo "Age Restriction: $age_restriction +<br>";



if ($more_info) echo "More Info: $more_info";


} 

else 
{ 
echo "There are currently no shows"; 
} 

}


else {







  $sql1 = "SELECT site_tourdates.id, DATE_FORMAT(site_tourdates.date,'%c/%e'), site_tourdates.description, site_tourdates_venues.name, site_tourdates_venues.street_address, site_tourdates_venues.city, site_tourdates_venues.state, site_tourdates_venues.country FROM site_tourdates, site_tourdates_venues WHERE site_tourdates.venue_id=site_tourdates_venues.id AND site_tourdates.date>=NOW() ORDER BY site_tourdates.date";




  $result1 = mysql_query($sql1,$dbh);

  $err = mysql_error();


 //if (mysql_num_rows($result1) > 0) //
{ 



  if ($err) { echo "$err"; die; }




  while (list($tourdate_id, $date, $description, $venue_name, $street_address, $venue_city, $venue_state, $venue_country ) = mysql_fetch_array($result1))  {



echo "<b>$date $venue_name</a> </b> <br> $description<br>";

echo "<u>Venue Details</u> <br>&nbsp;<br> $venue_name<br>&nbsp;<br>Address:<br>$street_address<br>$venue_city, $venue_state &nbsp; $zipcode<br>
";

echo "<b><a href=\"http://maps.google.com/maps?q=$street_address+$city,+$state,+$zipcode\" target=\"_blank\">
<u>View Map</u></b> </a> <br> 

";



if ($country != 'US') echo "$country<br>";



if (!$phone_number) $phone_number="N/A";

echo "&nbsp;<br>Phone Number: $phone_number<br>&nbsp;<br>";



if ($age_restriction) echo "Age Restriction: $age_restriction +<br>";



if ($more_info) echo "More Info: $more_info";

echo "<hr>";
  }



  if (mysql_num_rows($result1)) echo "&nbsp;<br>&nbsp;<br>";

}



}



?>