= NOW() order by date_start asc"; $res = mysql_query($sql); $j=0; $numrows = mysql_numrows($res); while ($j<$numrows){ $id = mysql_result($res,$j,"id"); $date_start = mysql_result($res,$j,"date_start_unix"); $date_end = mysql_result($res,$j,"date_end_unix"); $date_deadline = mysql_result($res,$j,"date_deadline_unix"); $name = mysql_result($res,$j,"name"); $location = mysql_result($res,$j,"location"); $url = mysql_result($res,$j,"url"); if (($date_deadline > time()) || ($date_deadline==0)){ $bgcol = "#cfc"; } else{ $bgcol = "#fcc"; } echo ""; $j++; } mysql_close(); ?>

Dates	Conference	Location	Deadline
" . (date('m/d/y',$date_start)) . ' - ' . (date('m/d/y',$date_end)) . "	" . $name . "	" . $location . "	"; if ($date_deadline != 0){ echo (date('m/d/y',$date_deadline)); } else{ echo " "; } echo "

	= Deadline passed.
	= Submission still open.

Past Conferences