function create_schedule_main($type, $limit) { switch($type) { case "nascar": $sql = "SELECT id, DATE_FORMAT( date, '%m.%d.%y' ) AS date, series, race, race_href, track, track_href, location FROM schedule WHERE CURRENT_DATE() <= date AND series='nascar' ORDER BY schedule.date ASC LIMIT $limit"; break; } $ret = db_query($sql); $schedule = ''; while ($row = mysql_fetch_array($ret)) { { $schedulemain['ID'] = $row['id']; $schedulemain['DATE'] = $row['date']; if($row['race_href']) $schedulemain['RACE'] = ""$row['race']""; else $schedulemain['RACE'] = $row['race']; $schedulemain['LOCATION'] = $row['location']; } $schedule .= template('/schedule/row.tpl', $schedulemain, 1); } return $schedule; }