00\n”;
}
### Determine if 01 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9901′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9901’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “01 \n”;
}
### Determine if 02 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9902′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9902’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “02 \n”;
}
### Determine if 03 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9903′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9903’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “03 \n”;
}
### Determine if 04 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9904′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9904’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “04 \n”;
}
### Determine if 05 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9905′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9905’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “05 \n”;
}
### Determine if 06 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9906′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9906’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “06 \n”;
}
### Determine if 07 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9907′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9907’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “07 \n”;
}
### Determine if 08 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9908′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9908’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “08 \n”;
}
### Determine if 09 is taken
$sql = “SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=’9909′”;
$result = mysql_query($sql)
or die(“Couldn’t execute query 24.”);
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = ”;
if($pFirst == ‘9909’)
{
$Selected = ‘Selected’;
}
}
if ($num == 0)
{
echo “09 \n”;
}
### Determine if 0-999 are taken
for ($x = 0; $x <= 999; $x++)
{
$sql = "SELECT dd.Number as Taken FROM driver_detail dd INNER JOIN drivers d ON d.Driver_ID = dd.Driver_ID WHERE d.Approved = 1 AND dd.Series_ID = $S_ID AND Number=$x";
$result = mysql_query($sql)
or die("Couldn't execute query 139.");
$num = mysql_num_rows($result);
if ($Error == 1)
{
$Selected = '';
if($pFirst == $x)
{
$Selected = 'Selected';
}
}
if ($num == 0)
{
echo "$x \n”;
}
}
echo “\n”;
echo “