john doe | cat 1 - 40+
Profile |
Races |
Blog");
?>
");
print ("| $variable1 | ");
print ("$variable2 | ");
print ("$variable3 | ");
print ("");
print ("");
print ("| $variable4 | ");
print ("
");
print ("");
print ("
| ");
print ("
");
}
}
else if ($which == 'Blog')
{
$query = mysql_query("SELECT *, date_format(EntryDate, '%m-%d-%Y') as 'ED' FROM RacerEntries where LicenseNumber = $licnum and EntryType = '$which' order by EntryDate desc");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["Title"];
$variable2=$row["ED"];
$variable3=$row["Description"];
print ("");
print ("| $variable1 | ");
print ("$variable2 | ");
print ("
");
print ("");
print ("| $variable3 | ");
print ("
");
print ("");
print ("
| ");
print ("
");
}
}
else if ($which == 'Profile')
{
$query = mysql_query("SELECT *, date_format(Birthdate, '%m-%d-%Y') as 'BD' FROM Racers where LicenseNumber = $licnum");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["FirstName"] ." ". $row["LastName"];
$variable2=$row["Category"];
$variable3=$row["BD"];
$variable4=$row["Birthplace"];
$variable5=$row["Nickname"];
$variable6=$row["FavoriteBike"];
$variable7=$row["MostProudOf"];
print ("");
print ("| Name: | $variable1 | ");
print (" | ");
print ("
");
print ("");
print ("| Race Category: | $variable2 | ");
print ("
");
print ("");
print ("| Birth Date: | $variable3 | ");
print ("
");
print ("");
print ("| Birthplace: | $variable4 | ");
print ("
");
print ("");
print ("| Nickname: | $variable5 | ");
print ("
");
print ("");
print ("| Favorite Ride: | $variable6 | ");
print ("
");
print ("");
print ("| Proudest Achievement: | $variable7 | ");
print ("
");
print ("");
print ("
| ");
print ("
");
}
}
?>