// gets number after ? in url
$uri = $_SERVER["REQUEST_URI"];
$startnumber = strstr($uri, '?');
$bandname = str_replace("?" , "" , $startnumber);
$bandname = str_replace( "%20" , " ", $bandname);
$bandname = str_replace( "+" , " ", $bandname);
if ($startnumber =="" ) $bandname ="";
include ("../dbinfo.php");
?>
Band photo's
include '../adds.php' ; ?>
Photo's
$query=" SELECT video1 FROM band WHERE name='$bandname' ";
$result=mysql_query($query);
while ($thisrow=mysql_fetch_row($result)) //get one row at a time
{
$video1 = $thisrow[0];
}
$query="select id, bandphototitle, bandphoto from bandphotos where bandname = '$bandname'";
$result=mysql_query($query);
$photocount = mysql_num_rows($result);
while ($thisrow=mysql_fetch_row($result)) //get one row at a time
{
if ($thisrow[2]<>"") echo ' ';
if ($thisrow[1]<>"") echo $thisrow[1]."
";
if ($thisrow[2]<>"") echo ' ';
}
?>
To The Gig List
To Band info page for a set list , contact information etc
if ($video1<>"")
{
?>