 |
|
| \n".$row_group[Group_Name]."\n | \n"; $result_profile = mysql_query("SELECT * FROM DB_Riders_Profile WHERE Profile_Group_Index = '$row_group[Group_Index]' ORDER BY Profile_Name",$conn); if ( mysql_num_rows($result_profile) == 0) { echo "||
| \n"; echo "kein Rider in diesem Bereich eingetragen!"; echo "\n | \n||
| \n";
if ($row_profile[Profile_Portrait]) { echo " | \n";
echo "\n";
echo "$row_profile[Profile_Name] "; echo $row_profile[Profile_Birth]." "; echo $row_profile[Profile_Nation]; echo " | \n"; echo "mehr"; echo "\n | \n
| ".$Group_Name." | "; echo "||
| Name: | "; echo "$row_profile[Profile_Name] | "; echo "";
if ($row_profile[Profile_Portrait]) { echo " | ";
echo "
| Birth: | "; echo "$row_profile[Profile_Birth] | "; echo "|
| Sign: | "; echo "$row_profile[Profile_Sign] | "; echo "|
| Homebase: | "; echo "$row_profile[Profile_Homebase] | "; echo "|
| State: | "; echo "$row_profile[Profile_State] | "; echo "|
| Nation: | "; echo "$row_profile[Profile_Nation] | "; echo "|
| Status: | "; echo "$row_profile[Profile_Phone] | "; echo "|
| Mobile: | "; echo "$row_profile[Profile_Mobile] | "; echo "|
| Fax: | "; echo "$row_profile[Profile_Fax] | "; echo "|
| e-Mail: | "; echo "";
$result_email = mysql_query("SELECT * FROM DB_Riders_Link WHERE Link_Profile_Index = '$Profile_Index' AND Link_Art = 'Email'",$conn);
while ($row_email = mysql_fetch_array($result_email, MYSQL_ASSOC))
{
echo " $row_email[Link_Name] "; } echo " | ";
echo "|
| Web: | "; echo "$row_profile[Profile_Web] | "; echo "|
| Slogan: | "; echo "".string_replace($row_profile[Profile_Slogan])." | "; echo "|
| Profession (learned): | "; echo "".string_replace($row_profile[Profile_Profession])." | "; echo "|
| Hobbies: | "; echo "".string_replace($row_profile[Profile_Hobbies])." | "; echo "|
| Favorite things: | "; echo "".string_replace($row_profile[Profile_Favorite])." | "; echo "|
| Teams: | "; echo "";
$result_team = mysql_query("SELECT * FROM DB_Riders_Link WHERE Link_Profile_Index = '$Profile_Index' AND Link_Art = 'Team'",$conn);
while ($row_team = mysql_fetch_array($result_team, MYSQL_ASSOC))
{
echo " $row_team[Link_Name] "; } echo " | ";
echo "|
| Sponsors: | "; echo "";
$result_sponsor = mysql_query("SELECT * FROM DB_Riders_Link WHERE Link_Profile_Index = '$Profile_Index' AND Link_Art = 'Sponsor'",$conn);
while ($row_sponsor = mysql_fetch_array($result_sponsor, MYSQL_ASSOC))
{
echo " $row_sponsor[Link_Name] "; } echo " | ";
echo "|
| Boards riding: | "; echo "";
$result_board = mysql_query("SELECT * FROM DB_Riders_Link WHERE Link_Profile_Index = '$Profile_Index' AND Link_Art = 'Board'",$conn);
while ($row_board = mysql_fetch_array($result_board, MYSQL_ASSOC))
{
echo " $row_board[Link_Name] "; } echo " | ";
echo "|
| Biggest success: | "; echo "".string_replace($row_profile[Profile_Success])." | "; echo "|
| Results: | "; echo "".string_replace($row_profile[Profile_Results])." | "; echo "|
| Presse: | "; echo "";
$result_presse = mysql_query("SELECT * FROM DB_Riders_Link WHERE Link_Profile_Index = '$Profile_Index' AND Link_Art = 'Presse'",$conn);
while ($row_presse = mysql_fetch_array($result_presse, MYSQL_ASSOC))
{
echo " $row_presse[Link_Name] "; } echo " | ";
echo "|
| Video: | "; echo "";
$result_video = mysql_query("SELECT * FROM DB_Riders_Link WHERE Link_Profile_Index = '$Profile_Index' AND Link_Art = 'Video'",$conn);
while ($row_video = mysql_fetch_array($result_video, MYSQL_ASSOC))
{
echo " $row_video[Link_Name] "; } echo " | ";
echo "|
| Story: | "; echo "".string_replace($row_profile[Profile_Story])." | "; echo "|
| Outlook: | "; echo "".string_replace($row_profile[Profile_Outlook])." | "; echo "|
| ";
if ($row_profile[Profile_Actionpicture]) { echo " | ";
echo "||