Members Listings
Country:
State:

Province:
Category:


0) { $where.=" and cu.deals_boats_members_type=".(int)$t; } if ($state != '') { $where.=" and ab.entry_state='".addslashes($state)."'"; } if ($country != '' && $country!='All') { $where .= " and ab.entry_country_id=".(int)$country; } $query = "SELECT ab.entry_company, ab.entry_street_address, ab.entry_city, ab.entry_state, ab.entry_postcode, cu.customers_id, cu.customers_telephone, cu.customers_email_address, cu.deals_boats_members_type FROM address_book ab, customers cu WHERE ab.customers_id = cu.customers_id AND cu.members_status>1 and cu.deals_boats_members_type!=5".$where." ORDER BY ab.entry_company"; WriteLog($query); $result = mysql_query($query); $num = mysql_num_rows($result); mysql_close(); $i=0; $cls = 2; $alpha = ''; while ($i < $num) { $id=mysql_result($result,$i,"customers_id"); $companyname=mysql_result($result,$i,"entry_company"); if(empty($companyname)) $companyname='---'; $address=mysql_result($result,$i,"entry_street_address"); // LG 2008-11-05 terry requiested no dashes if empty address //if(empty($address)) $address='---'; $city=mysql_result($result,$i,"entry_city"); if(empty($city)) $city='---'; $state=mysql_result($result,$i,"entry_state"); if(empty($state)) $state='---'; $zip=mysql_result($result,$i,"entry_postcode"); if(empty($zip)) $zip='---'; $phone=mysql_result($result,$i,"customers_telephone"); if(empty($phone)) $phone='---'; $email=mysql_result($result,$i,"customers_email_address"); if(empty($email)) $email='---'; $deals_boats_members_type=mysql_result($result,$i,"deals_boats_members_type"); //$listing=mysql_result($result,$i,"listing"); if($cls == 2) $cls = 1; else $cls = 2; ?>
Name Address Phone Number E-Mail Address
'; } // LG 2008-8-25 // select either base pages or web pages if ($deals_boats_members_type==4) { //$link='viewer_advertisements-'.CompanyNameIdUrl($companyname,$id).'.php'; $link = preg_replace('/\W/','',$companyname).'-webpage2-'.$id.'.php'; //$link='viewer_advertisements.php?advertiser_id='.$id; // LG 2009-12-13 change url } else { #lg 2009-03-22 change url #$link='webpage.php?company_id='.$id; //$link='webpage-'.CompanyNameIdUrl($companyname,$id).'.php'; $link = preg_replace('/\W/','',$companyname).'-webpage-'.$id.'.php'; // 2010-03-19 LG changed url } ?> '; } ?> , Email Us
No results, Come back Soon!