"; print""; while($contests = mysql_fetch_array($ctest)){ $entries = mysql_num_rows(mysql_query("select * from contest_entries where contest=$contests[id]")); print""; if($contests[vote]==1){ print""; }else{ print""; } print""; } $bnowcontest = mysql_fetch_array(mysql_query("select * from contest_contest where active=1 limit 1")); if(!$bnowcontest[id]){ $nextcontest = mysql_fetch_array(mysql_query("select * from contest_contest where active=0 order by id asc limit 1")); mysql_query("update contest_contest set active=1 where id=$nextcontest[id]"); } $bnowcontest = mysql_fetch_array(mysql_query("select * from contest_contest where active=1 limit 1")); if(!$bnowcontest[id]){ $bnowcontest[name]="ERROR"; $bnowcontest[des]="There is an error.... most likely there is no contest set"; } $entries = mysql_num_rows(mysql_query("select * from contest_entries where contest=$bnowcontest[id]")); print""; $ctest = mysql_query("select * from contest_contest where active=0 order by id asc"); while($contests = mysql_fetch_array($ctest)){ print""; } print"

Contest theme	Entries	enter/vote
$contests[name]	$entries	VOTE	WINNERS
$bnowcontest[name]	$entries	ENTER
$contests[name]	-	-

";