Seven Pickles

Concert Chronology

';

include $_SERVER['DOCUMENT_ROOT'] . '/sql/mysql_connect.php';

if(isset($_GET[artist])) {
$searchartist=$_GET[artist];
$psearchartist=stripslashes($_GET[artist]);

$atdisplay = 1;

$where="WHERE feature LIKE CONVERT( _utf8 '$searchartist' USING latin1 ) COLLATE latin1_swedish_ci OR support LIKE CONVERT( _utf8 '%$searchartist%' USING latin1 )";
echo '

Viewing events featuring ' . $psearchartist . '
View the entire chronology

';
} else {$where='';}

$query = "SELECT DATE_FORMAT(date, '%W, %M %D, %Y') as date2, DATE_FORMAT(thru, '%W, %M %D, %Y') as date3, date, thru, solo, venue, city, feature, uid, support, setlist, rev, extra, rating, attend, poster, stub, mvfest, eban, sban, sban_num, sban_name FROM concerts ";

$query .= $where;

$query .= "ORDER BY date DESC";

$result=@mysql_query($query);

$num_rows = mysql_num_rows($result);

if ($result)

{

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

switch ($atdisplay) {
case '1': $colspan=2;
break;
case '0':

if ($row['mvfest']==1) {$colspan=1;} else {$colspan=2;}

break;
}

if ($row['stub']==1) {$showstub=$row['extra'];} else {$showstub="nostub";}

echo '


' . $num_rows .'

' . $row['date2']; ## DATE

if ($row['thru']!='0000-00-00') {echo ' through ' . $row['date3'] . '
';} else {echo '
';}

echo ''; ## VENUE & CITY

if ($row['venue']!='') {echo $row['venue'] . ' / ';}

echo $row['city'] . '

' . $row['feature'] . ''; ## HEADLINER

if ($row['thru']!='0000-00-00') {echo '
featuring ' . $row['support'] . '';} ## FEST SUPPORT

if ($row['thru']=='0000-00-00' && $row['solo']!='yes') {echo '
with ' . $row['support'] . '';} ## SOLO SUPPORT

if ($row['setlist']!='' || $row['poster']!='') {echo "

";

if($atdisplay!=1) {

if ($row['eban']==1) {echo '


';} else {echo '


';}

if ($row['sban']==1) {echo '

';}

} else {echo '


';}

$num_rows=$num_rows-1;

} }

mysql_close();

echo '

';

?>

Sections

Features

Time for Chili!
I find it awesome, you may find it pointless - just like a clock in a hat.

Categories