schedule_calib0rx

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;
	case "nationwide": $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='nationwide' ORDER BY schedule.date ASC LIMIT $limit";
	break;
	case "appearance": $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='appearance' ORDER BY schedule.date ASC LIMIT $limit";
	break;}
$ret = db_query($sql);
$schedule = '';
while ($row = mysql_fetch_array($ret)) 
	{ 
		{//DATA INSERT /ROW
			$schedulemain['ID'] = $row['id'];
			$schedulemain['DATE'] = $row['date'];
			if($row['race_href'])
				$schedulemain['RACE'] = "<a href="$row['race_href']" target=\"_blank\">"$row['race']"</a>";
            else 
				$schedulemain['RACE'] = $row['race'];
			$schedulemain['LOCATION'] = $row['location'];
		}//END DATA INSERT /ROW
		$schedule .= template('/schedule/row.tpl', $schedulemain, 1);
	}//END while ($row = mysql_fetch_array($ret)) 
return $schedule;}