[RESOLVED] Displaying all content, instead of individual (Calendar)

[Twilite_Kid_82]

Hey

the way the page is set up now, it lists each show as a link. and when you click that show it opens up a page for that specific show with all the information.

What I would like to do is instead of one individual page per show.. I would like to list all the information for all the shows on one page

here's the code as it is now

<?php

$page_title = "SHOWS";

require("header.php");

?>


<?



if ($show) {



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

$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</u> <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>

";



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.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, $venue_city, $venue_state, $venue_country ) = mysql_fetch_array($result1))  {





echo "<b><a href=\"shows.php?show=$tourdate_id\">$date $venue_city, $venue_state - $venue_name</a> </b> <br> $description<br>"
;


  }



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

}

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


}



?>

[dagon]

if you removed

WHERE id=$show LIMIT 1

you would get info for all the shows.

--
Book Bloodhound - Can't find it? I can.
http://www.bookbloodhound.com

[Twilite_Kid_82]

progress made in post below

[Twilite_Kid_82]

Ok, I modified the code and was able to produce kind of what i wanted.. I would ilke to add a <HR> line after each show to break it up.. I keep getting errors when I add the code tho

and here's the code

<?



if ($show) {



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

$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</u> <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>

";



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.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, $venue_city, $venue_state, $venue_country ) = mysql_fetch_array($result1))  {


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



echo "<u>Venue Details</u> <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>

";



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 <br> <hr>";
;

 }



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

}

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


}


?>

[dagon]

if ($more_info) echo "More Info: $more_info <br> <hr>";
; 

you will only get the <hr> if $more_info is set, so you probably want an

echo '<hr>';

by itself at the end, and you have an extra ;

[Twilite_Kid_82]

I just tried that and also put it right before the else( got a parse error, unexpected T_ELSE), and a few other places but the HR only appears at the bottom once, not in between each seperate event..

here's a snippet of where i stuck in the <HR> code on the problematic page

if ($more_info) echo "More Info: $more_info <br> <hr>";

 }



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

}

echo '<hr>'; 

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


}

[Twilite_Kid_82]

k, I finally fixed the <hr> problem 🙂 ..
placed it like you said

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


echo "<hr>";