= '$today' ORDER BY date LIMIT 0, 5") or die(mysqli_error());
echo "
See More...
Current Supporting Acts"; if (!mysqli_num_rows($sql)) { echo "Saves The Day is not on tour. There are no current supporting acts.";
}
else
{
while($row = mysqli_fetch_array( $sql ))
{
echo "![](\"$row[link]\")
";
echo "";
}
}
?>
See More...
See More...
= '$today' ORDER BY date") or die(mysqli_error());
echo "
Current Supporting Acts
"; if (!mysqli_num_rows($sql)) { echo "Saves The Day is not on tour. There are no current supporting acts.";
}
else
{
while($row = mysqli_fetch_array( $sql ))
{
echo "
"; echo "members | $row[members]
"; echo "songs | $row[songs]
"; echo "official site | $row[site]
"; echo "
"; // Print out the contents of each row into a table } } echo "
";
}
elseif ($action == 'reviews')
{
if (!isset($safe_sort))
{
$result_review = mysqli_query($db, "SELECT * FROM tourreview ORDER BY id DESC") or die(mysqli_error());
}
elseif($safe_sort == 'date')
{
$result_review = mysqli_query($db, "SELECT * FROM tourreview ORDER BY date DESC") or die(mysqli_error());
}
elseif($safe_sort == 'location')
{
$result_review = mysqli_query($db, "SELECT * FROM tourreview ORDER BY location") or die(mysqli_error());
}
?>
$row[venue] - $row[location]";
$month = substr($row['date'], 5, 2);
$day = substr($row['date'], 8, 2);
$year = substr($row['date'], 0, 4);
echo $month . '.' . $day .'.' . $year."
"; echo "by ". $row['author']."
"; echo "Supporting Acts: ".$row['support'] ."
"; echo $row['review']; } ?>
Tour Dates
"; if (!mysqli_num_rows($result_dates)) { echo "Saves the Day are not currently on tour"; } else { ?>
Date |
Location |
Venue |
Buy |
"; $month = substr($row['date'], 5, 2); $day = substr($row['date'], 8, 2); $year = substr($row['date'], 0, 4); echo $month . '.' . $day .'.' . $year ." | "; echo "" .$row[location] ." | "; echo "" .$row[venue] ." | "; if (!$row[tix]) { echo "--- | "; } else { echo "Buy | "; } echo "
Current Supporting Acts"; if (!mysqli_num_rows($sql)) { echo "
"; echo "$row[name]"; echo "
"; echo "Recently Added Reviews
Location |
Date |
Author |
$row2[venue] - $row2[location] | "; echo ""; $month = substr($row2['date'], 5, 2); $day = substr($row2['date'], 8, 2); $year = substr($row2['date'], 0, 4); echo $month . '.' . $day .'.' . $year ." | ";
echo $row2['author']." "; echo " |
Tour Dates
"; if (!mysqli_num_rows($result_dates)) { echo "Saves the Day are not currently on tour"; } else { ?>
Date |
Location |
Venue |
Buy |
"; $month = substr($row['date'], 5, 2); $day = substr($row['date'], 8, 2); $year = substr($row['date'], 0, 4); echo $month . '.' . $day .'.' . $year ." | "; echo "" .$row['location'] ." | "; echo "" .$row['venue'] ." | "; if (!$row['tix']) { echo "--- | "; } else { echo "Buy | "; } echo "
"; if (!mysqli_num_rows($sql)) { echo "
";
echo "
";
echo ""; echo "$row[name]"; echo "
"; echo "from | $row[origin]"; echo "members | $row[members]
"; echo "songs | $row[songs]
"; echo "official site | $row[site]
"; echo "
"; // Print out the contents of each row into a table } } echo "
Past Supporting Acts
"; $sql2 = mysqli_query($db, "SELECT * FROM support WHERE active = 'N' ORDER BY name") or die (mysqli_error()); $num = 1; echo "| ";
while($row2 = mysqli_fetch_array( $sql2 ))
{
echo "$row2[name] "; $num++; if ($num%7 == 0) { echo " | ";
}
}
echo " |
Show Reviews
Sort by Date Added | Year | Location
Location |
Date |
Author |
$row2[venue] - $row2[location] | "; echo ""; $month = substr($row2['date'], 5, 2); $day = substr($row2['date'], 8, 2); $year = substr($row2['date'], 0, 4); echo $month . '.' . $day .'.' . $year ." | ";
echo $row2['author']." "; echo " |
"; echo "by ". $row['author']."
"; echo "Supporting Acts: ".$row['support'] ."
"; echo $row['review']; } ?>