[MarkB]

Hi,

My idea for this hack was two pull the next 10 events from the calendar table, sort them by date, and have them displayed in individual table rows so I can display them in a side column on index.php (within their own table of course) -- see the right-side column of www.ultimatemetal.com/forum/ for placement idea.

Anyway, I have problems. I can pull the data out fine, but when displayed, it displays all dates in one cell, all subjects in another, etc:

May 1May 2May3 May4

etc...

This is the code:

In index.php, before $birthdaybits=""; I put:

$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) and ++$bgcounter) {
 $gigid .= $gig['eventid'];
 $gigdate .= $gig['gigdate'];
 $gigband .= "<a href=$bburl/shows.php?s=&action=getinfo&eventid=" . $gig['eventid'] . ">" . $gig['subject'] . "</a>";
 $gigcity .= $gig['country'];
}

unset($gigbits);
$DB_site->free_result($events);
// eval("\$gigbits = \"".gettemplate("gigbits")."\";");
// eval("\$nextgigs = \"".gettemplate("gigs")."\";");

(note the two extra table fields I've added in calendar for my hack)

Template gigs is just a table with two header rows, and then $gigbits where I want the content rows to be added.

template gigbits is just:

<tr bgcolor="$bgcolor">
<td nowrap><smallfont>$gigdate</font></td>
<td><smallfont>$gigband</font></td>
<td><smallfont>$gigcity</font></td></tr>

Is there anything else I need to do to make sure each individual record has its own row? Or is it just not possible? I did have it being called from an external PHP into index.php, but that seemed to slow everything down (possibly because of an extra 10 queries when loading the page?).

Please help :ermm: