View contact data from mSQL database

%s

\n", $ERRMSG); fatal(" "); } if (msqlSelectDB($sock,"contacts") < 0) { printf("

%s

\n", $ERRMSG); fatal(" "); } if (msqlQuery($sock, "select name,surname,titula,jobtitle,company,dept,h_street,h_city,h_zip,h_country,h_phone,w_street,w_city,w_zip,w_country,w_phone,mailing_addr,pager,mobil_phone,email,home_page,categories,public, account from $user where rbr=$rbr order by surname")<0) { printf("

%s

\n", $ERRMSG); fatal(" "); } $res=msqlStoreResult(); $row=msqlFetchRow($res); if (#$row > 0) { echo("
\n"); echo("

\n"); printf("
Name: | %s, %s
\n", $row[1], $row[0]); if ($row[2] != "") { printf("
Title: | %s
\n", $row[2]); } if ($row[3] != "") { printf("
Job Title: | %s
\n", $row[3]); } printf("
Home Address
\n"); printf("
Street: | %s
\n", $row[6]); printf("
Zip, City: | %s %s
\n", $row[8], $row[7]); printf("
Country: | %s
\n", $row[9]); printf("
Phone: | %s
\n",$row[10]); printf("
Account No: | %s
\n",$row[23]); if ($row[17] != "") { printf("
Pager: | %s
\n",$row[17]); } if ($row[18] != "") { printf("
Mobile: | %s
\n",$row[18]); } if ($row[19] != "") { printf("
E-mail: | %s
\n",$row[19], $row[19]); } if ($row[20] != "") { printf("
Home Page: | %s
\n",$row[20], $row[20]); } echo("

\n"); } msqlFreeResult($res); >