How do I set up this database and php correctly to minimize maintenance

<?
echo "<select name=\"car_number\">";
$query="SELECT * FROM cars ORDER BY number";
if (!($result=mysql_query($query))) {
  // query failed.  report and ...
  die();
}
while ($row=mysql_fetch_assoc($result)) {
  echo "<option value=\"{$row['id']}\">{$row['number']}</option>";
}
echo "</select>";
?>

Select allOpen in new window

<?php include("includes/Header.html"); ?>
<?php include("includes/conn.php"); ?>


<table border=1 align="center" width=1200>

<tr>
<td><p>&nbsp;</p></td>
</tr>
<tr>
<td width=50><p>Car #</p></td>
<?php
$sqlstr = mysql_query("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
while($row=mysql_fetch_array($sqlstr)){

echo "</td><td width=50 align=center>";
echo date('m/d', strtotime($row['Date']));
echo "</td>";
}
echo "<td width=50 align=center>Total</td>";
echo "</tr>";


$sqlstr2 = mysql_query("SELECT * FROM Roster");
while($row=mysql_fetch_array($sqlstr2)){

echo "</td><td width=50>";
echo $row['Car_Number'];
echo "</td></tr>";
}




echo "</table>";

?>

Select allOpen in new window

SELECT Date, Car_Number, Points FROM Results a INNER JOIN Roster b ON a.Roster_Number=b.Roster_Number INNER JOIN Schedule d ON a.Race_Number=d.Race_Number WHERE exists (Select Race_Number from Schedule where PointsAwarded not like "*")

Select allOpen in new window

<?
$myarray=array();
$datearray=array();
while ($row=mysql_fetch_assoc($points_result)) {
  $myarray[$row['Car_Number']][$row['Date']]=$row['Points'];
}
while ($row=mysql_fetch_assoc($date_result)) {
  $datearray[]=$row['Date'];
echo "<table>";
foreach ($myarray as $key=>$val) {
  echo "<tr><td>$key</td>";
  foreach ($datearray as $key2=>$val2) {
    echo "<td>",((array_key_exists($val2,$val))?$val[$val2]:0),"</td>";
  }
  echo "</tr>";
}
echo "</table>";
?>

Select allOpen in new window

<?php include("includes/Header.html"); ?>
<?php include("includes/conn.php"); ?>


<table border=1 align="center" width=1200>

<tr>
<td width=50><p>Car #</p></td>
<?php
$sqlstr = mysql_query("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
while($row=mysql_fetch_array($sqlstr)){

echo "</td><td width=50 align=center>";
echo date('m/d', strtotime($row['Date']));
echo "</td>";
}
echo "<td width=50 align=center>Total</td>";
echo "</tr>";
?>
<?php
$points_result = mysql_query("SELECT Date, Car_Number, Points FROM Results a INNER JOIN Roster b ON a.Roster_Number=b.Roster_Number INNER JOIN Schedule d ON a.Race_Number=d.Race_Number WHERE exists (Select Race_Number from Schedule where PointsAwarded not like '*')");
$date_result = mysql_query ("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
$myarray=array();
$datearray=array();
while ($row=mysql_fetch_assoc($points_result)) {
  $myarray[$row['Car_Number']][$row['Date']]=$row['Points'];
}
while ($row=mysql_fetch_assoc($date_result)) {
  $datearray[]=$row['Date'];}
foreach ($myarray as $key=>$val) {
  echo "<tr><td width=50>$key</td>";
  foreach ($datearray as $key2=>$val2) {
    echo "<td width=50>",((array_key_exists($val2,$val))?$val[$val2]:0),"</td>";
  }
  echo "</tr>";
}
echo "</table>";
?>

Select allOpen in new window

<?php include("includes/Header.html"); ?>
<?php include("includes/conn.php"); ?>


<table border=1 align="center" width=1200>

<tr>
<td width=50><p>Car #</p></td>
<?php
$sqlstr = mysql_query("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
while($row=mysql_fetch_array($sqlstr)){

echo "</td><td width=50 align=center>";
echo date('m/d', strtotime($row['Date']));
echo "</td>";
}
echo "<td width=50 align=center>Total</td>";
echo "</tr>";
?>
<?php
$points_result = mysql_query("SELECT c.Date, b.Roster_Number, b.Car_Number, a.Points, b.PointTotal
FROM Results a
INNER JOIN Schedule c ON a.Race_Number = c.Race_Number
INNER JOIN (
    SELECT g.Roster_Number, g.Car_Number, SUM( f.Points ) AS PointTotal
    FROM Results f
    INNER JOIN Roster g ON f.Roster_Number = g.Roster_Number
    GROUP BY g.Roster_Number,g.Car_Number)b ON a.Roster_Number = b.Roster_Number order by b.PointTotal desc");
	
$date_result = mysql_query ("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
$myarray=array();
$datearray=array();
while ($row=mysql_fetch_assoc($points_result)) {
  $myarray[$row['Car_Number']][$row['Date']]=$row['Points'];
}
while ($row=mysql_fetch_assoc($date_result)) {
  $datearray[]=$row['Date'];}
foreach ($myarray as $key=>$val) {
  echo "<tr><td width=50>$key</td>";
  foreach ($datearray as $key2=>$val2) {
    echo "<td width=50>",((array_key_exists($val2,$val))?$val[$val2]:0),"</td>";
  }
  echo "</tr>";
}
echo "</table>";
?>

Select allOpen in new window

<?php include("includes/Header.html"); ?>
<?php include("includes/conn.php"); ?>


<table border=1 align="center" width=1200>

<tr>
<td width=50><p>Car #</p></td>
<?php
$sqlstr = mysql_query("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
while($row=mysql_fetch_array($sqlstr)){

echo "</td><td width=50 align=center>";
echo date('m/d', strtotime($row['Date']));
echo "</td>";
}
echo "<td width=50 align=center>Total</td>";
echo "</tr>";
?>
<?php
$points_result = mysql_query("SELECT c.Date, b.Roster_Number, a.Points, b.PointTotal
FROM Results a
INNER JOIN Schedule c ON a.Race_Number = c.Race_Number
INNER JOIN (
SELECT g.Roster_Number, SUM( f.Points ) AS PointTotal
FROM Results f
INNER JOIN Roster g ON f.Roster_Number = g.Roster_Number
GROUP BY g.Roster_Number
)b ON a.Roster_Number = b.Roster_Number order by b.PointTotal desc");
	
$date_result = mysql_query ("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
$myarray=array();
$datearray=array();
while ($row=mysql_fetch_assoc($points_result)) {
  $myarray[$row['Car_Number']][$row['Date']]=$row['Points'][$row['PointTotal']];
}
while ($row=mysql_fetch_assoc($date_result)) {
  $datearray[]=$row['Date'];}
foreach ($myarray as $key=>$val) {
  echo "<tr><td width=50>$key</td>";
  foreach ($datearray as $key2=>$val2) {
    echo "<td width=50>",((array_key_exists($val2,$val))?$val[$val2]:0),"</td>";
  }
  echo "</tr>";
}
echo "</table>";
?>

Select allOpen in new window

<?php include("includes/Header.html"); ?>
<?php include("includes/conn.php"); ?>


<table border=1 align="center" width=1200>

<tr>
<td width=50><p>Car #</p></td>
<?php
$sqlstr = mysql_query("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
while($row=mysql_fetch_array($sqlstr)){

echo "</td><td width=50 align=center>";
echo date('m/d', strtotime($row['Date']));
echo "</td>";
}
echo "<td width=50 align=center>Total</td>";
echo "</tr>";
?>
<?php
$points_result = mysql_query("SELECT c.Date, b.Roster_Number, b.Car_Number, a.Points, b.PointTotal
FROM Results a
INNER JOIN Schedule c ON a.Race_Number = c.Race_Number
INNER JOIN (
    SELECT g.Roster_Number, g.Car_Number, SUM( f.Points ) AS PointTotal
    FROM Results f
    INNER JOIN Roster g ON f.Roster_Number = g.Roster_Number
    GROUP BY g.Roster_Number,g.Car_Number)b ON a.Roster_Number = b.Roster_Number order by b.PointTotal desc");
	
$date_result = mysql_query ("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
$myarray=array();
$datearray=array();
while ($row=mysql_fetch_assoc($points_result)) {
  $myarray[$row['Car_Number']][$row['Date']]=$row['Points'][$row['PointTotal']];
}
while ($row=mysql_fetch_assoc($date_result)) {
  $datearray[]=$row['Date'];}
foreach ($myarray as $key=>$val) {
  echo "<tr><td width=50>$key</td>";
  foreach ($datearray as $key2=>$val2) {
    echo "<td width=50>",((array_key_exists($val2,$val))?$val[$val2]:0),"</td>";
  }
  echo "</tr>";
}
echo "</table>";
?>

Select allOpen in new window

<?php include("includes/Header.html"); ?>
<?php include("includes/conn.php"); ?>


<table border=1 align="center" width=1200>

<tr>
<td width=50><p>Car #</p></td>
<?php
$sqlstr = mysql_query("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");
while($row=mysql_fetch_array($sqlstr)){

echo "</td><td width=50 align=center>";
echo date('m/d', strtotime($row['Date']));
echo "</td>";
}
echo "<td width=50 align=center>Total</td>";
echo "</tr>";
?>
<?php
$points_result = mysql_query("SELECT c.Date, b.Roster_Number, b.Car_Number, a.Points, b.PointTotal
FROM Results a
INNER JOIN Schedule c ON a.Race_Number = c.Race_Number
INNER JOIN (
    SELECT g.Roster_Number, g.Car_Number, SUM( f.Points ) AS PointTotal
    FROM Results f
    INNER JOIN Roster g ON f.Roster_Number = g.Roster_Number
    GROUP BY g.Roster_Number,g.Car_Number)b ON a.Roster_Number = b.Roster_Number order by b.PointTotal desc");
	
$date_result = mysql_query ("SELECT Date FROM Schedule WHERE `Schedule`.`PointsAwarded` = ' ' ORDER BY `Schedule`.`Date` ASC");

$point_total = mysql_query ("SELECT g.Car_Number, SUM( f.Points ) AS PointTotal
FROM Results f
INNER JOIN Roster g ON f.Roster_Number = g.Roster_Number
GROUP BY g.Car_Number order by PointTotal desc");

$myarray=array();
$datearray=array();
$totalarray=array();

while ($row=mysql_fetch_assoc($points_result)) {
  $myarray[$row['Car_Number']][$row['Date']]=$row['Points'];
}
while ($row=mysql_fetch_assoc($date_result)) {
  $datearray[]=$row['Date'];}

while ($row=mysql_fetch_assoc($point_total)) {
  $totalarray[]=$row['PointTotal'];}
  
foreach ($myarray as $key=>$val) {
	echo "<tr><td width=50>$key</td>";
 
	foreach ($datearray as $key2=>$val2) {
		echo "<td width=50>",((array_key_exists($val2,$val))?$val[$val2]:0),"</td>";
  }
  
	$val3 = current($totalarray); 
	echo "<td width=50>$val3</td>";
	$val3 = next($totalarray); 
}

echo "</tr>";
  
echo "</table>";
?>

Select allOpen in new window