mul_vals("SELECT location,status,posts,regdate,lastdate FROM members WHERE uid='$val'");
//list($name,$status)=user_stuff($val);
//if($location=='') {
//$location=' ';
//}
$tourdatesiddb = new db_sql;
$tourdatesdb = new db_sql;
$venuedb = new db_sql;
if($olddates==yes){
$q="SELECT * FROM tourdates where (year=$todaysyear and month<$todaysmonth) or (year=$todaysyear and month=$todaysmonth and day<$todaysday) or year<$todaysyear order by year, month, day, time";
}else{
$q="SELECT * FROM tourdates where (year=$todaysyear and month>$todaysmonth) or (year=$todaysyear and month=$todaysmonth and day>=$todaysday-1) or year>$todaysyear order by year, month, day, time";
}
$num=$tourdatesiddb->num_vals($q);
$pnum=sizeof($num);
//echo "testing, ignore(results):".$pnum."
";
if ($pnum==0) {echo "There are no tour dates at this time. Please check back soon.";
}else{
$pnum--;
$totnum="0";
while ($totnum<=$pnum) {
$tourdateid=$num[$pnum];
//echo "testing".$tourdateid." val / end ";
$r="Select month, day, year, time, notes, venue FROM tourdates where tourdateid=$tourdateid";
list($month, $day, $year, $time, $notes, $venue)=$tourdatesdb->mul_vals($r);
$s="Select website, address, map, city, state, file FROM venue where venue='$venue'";
list($website, $address, $map, $city, $state, $file)=$venuedb->mul_vals($s);
//echo $month."/".$day."/".$year."@".$time."
".$notes."
";
//echo $venue."
".$address." ".$city." ".$state."
".$website." ".$map." ".$file."
";
?>
|
|
|
|
|
|
|
|
|
MAP
|
FILE
|
|