Job Fairs
";
print banner_display(1);
print "
";
$gigssql = mysql_query("SELECT * FROM event JOIN node ON event.nid = node.nid AND node.status = 1 INNER JOIN term_node ON node.nid = term_node.nid WHERE term_node.tid = $taxo_id AND event.event_end >= '$currenttime' ORDER BY event.event_start"); // look in the event table in the drupal database
while ($row = mysql_fetch_row($gigssql)) {
$timestamp = $row[1] - (6 * 60 * 60);
$gigdate= gmdate("Y M j ", $timestamp); // formats the date of the event
print "| $row[6] | $gigdate |
"; // outputs each event on an individual line with a link to more details.
}
print "
";
?>