'; //Page Title End //Page Header Funtion function title() {} // Header Include Statment Start--> require_once($path . 'header.php'); // Header Include Statment End --> ?>
"; require "../config.php"; $Cquery = "SELECT contest_id, status FROM $db2.$table10 WHERE racer_id = '". $userdata['user_id'] ."'"; $Cresult = mysql_query($Cquery) or die("Query failed : " . mysql_error()); $total = mysql_num_rows($Cresult); if ($total == 0) {echo "";} else { while ($contest = mysql_fetch_array($Cresult, MYSQL_ASSOC)) { $Aquery = "SELECT id, start, racers, name, owner, owner_id, type, car, status FROM $db2.$table9 WHERE id = '". $contest['contest_id'] ."'"; $Aresult = mysql_query($Aquery) or die("Query failed : " . mysql_error()); while ($line = mysql_fetch_array($Aresult, MYSQL_ASSOC)) { if ($line['car'] > 0) { $main1 = "SELECT * FROM $table4 WHERE link = '". $line['car'] ."'"; $mresult1 = mysql_query($main1) or die("Query failed : " . mysql_error()); $parse1 = mysql_fetch_array($mresult1); $cars = $parse1['cars']; $main2 = "SELECT car FROM $table5 WHERE id = '$cars'"; $mresult2 = mysql_query($main2) or die("Query failed : " . mysql_error()); $parse2 = mysql_fetch_array($mresult2); $car_name = $parse2['car']; } else {$car_name = 'N / A';} echo "" . "" . "" . "" . "" . "" . "" . ""; if ($line['status'] == 'Racing' | $line['status'] == 'Ended' & $contest['status'] != 'Wimped-Out') { echo ""; } else{ echo ""; } if ($contest['status'] == 'Applied' | $contest['status'] == 'Accepted') { echo ""; } else { echo ""; } echo ""; } } } echo "
Race List For ". $userdata['username'] ."
 Start Date   Name   Owner   Type   Car   Contest   Status   Tree   Wimp-Out 

You are not entered in any contests

 " . date("F d, Y", $line['start']) . "  " . htmlspecialchars($line['name']) . "  " . htmlspecialchars($line['owner']) . "  " . $line['type'] . "  " . $car_name . "  " . $line['status'] . "  " . $contest['status'] . " 
N / A
N / A

"; ?>