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)) !== FALSE) { { $schedulemain['ID'] = $row['id']; $schedulemain['DATE'] = $row['date']; if(strlen(trim($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; }