Thanks for the response
I'm getting closer to my desired result, but still having problems...
With this code:
PHP Code:
$events = $DB_site->query("SELECT eventid, DATE_FORMAT(eventdate,'%M %d') AS gigdate, eventdate, subject, location, country FROM calendar_events WHERE public='1' ORDER BY eventdate LIMIT 10");
while ($gig = $DB_site->fetch_array($events)) {
$gigid .= $gig['eventid'];
$gigdate .= $gig['gigdate'];
$gigband .= "<a href=$bburl/shows.php?s=&action=getinfo&eventid=" . $gig['eventid'] . ">" . $gig['subject'] . "</a>";
$gigcity .= $gig['country'];
eval("\$gigbits .= \"".gettemplate("gigbits")."\";");
eval("\$nextgigs .= \"".gettemplate("gigs")."\";");
}
I'm getting this result (attached). Any ideas? :ermm: