|
There are " . mysql_num_rows($result) ." results for your query. ";
echo " ";
$x=1;
for ($count=0; $count"; } else { $x++; }
echo"";
$client_name = mysql_result($result,$count,"clients.client_name");
$client_street = mysql_result($result,$count,"clients.client_street");
$client_suburb = mysql_result($result,$count,"clients.client_suburb");
$client_postcode = mysql_result($result,$count,"clients.client_postcode");
$client_phone = mysql_result($result,$count,"clients.client_phone");
$client_fax = mysql_result($result,$count,"clients.client_fax");
$client_mobile = mysql_result($result,$count,"clients.client_mobile");
$client_email = mysql_result($result,$count,"clients.client_email");
$client_url = mysql_result($result,$count,"clients.client_url");
$client_description = mysql_result($result,$count,"clients.client_description");
$client_description = ereg_replace("\n", "
", $client_description);
if ( strlen($client_name)) {
echo "$client_name | ";
if (strlen($client_street)) {
echo "| Address: | $client_street, $client_suburb, $client_postcode | ";
}
if (strlen($client_phone)) {
echo "| Telephone: | $client_phone | ";
}
if (strlen($client_fax)) {
echo "| Facsimilie: | $client_fax | ";
}
if (strlen($client_mobile)) {
echo "| Mobile: | $client_mobile | ";
}
if (strlen($client_email)) {
echo "| Email: | Click Here | ";
}
if (strlen($client_url)) {
echo "| Website: | Click Here | ";
}
if (strlen($client_description)) {
echo "| Description: | $client_description | ";
}
}
echo " | ";
}
echo "
";
?>
|
