function string_replace($String) { $String = nl2br($String); $String = eregi_replace("\t"," ", $String); return $String; } require("../sqlinit/sql_init.php3"); $conn = mysql_connect($SQL_Server,$SQL_User,$SQL_Pass); $select = mysql_select_db($SQL_DB,$conn); ?>
\n".$row_group[Group_Name]."\n | \n||
\n"; echo "kein Rider in diesem Bereich eingetragen!"; echo "\n | \n||
\n"; if ($row_profile[Profile_Portrait]) { echo ""; } echo "\n | \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 " | "; 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 " | "; echo "