frickfrack Posted September 7, 2010 Share Posted September 7, 2010 Hello, If anyone can help please let me know. The 2 files below are what's used to render the "Frickster's ListRave Posts" at the following URL http://www.listrave.com/member/profile.php?id=24. You can see that under Antiques it lists the same ads under both York and Altoona. The script is identifying all ads posted by User ID 24 but I don't know why it is duplicating those ads in the 2 different cities. There should actually be 2 ads for York and one for Altoona. The code is below. Again, please help Here's the code to pull the info from the data base (called memberall_listings.php) $conn = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die ('Error connecting to mysql'); mysql_select_db($dbname1) or die('Could not connect: ' . mysql_error()); $tables = mysql_list_tables($dbname1); while (list($table) = mysql_fetch_row($tables)) { $site["tablename"][] = $table; } if($_REQUEST["id"]!='') $getmemberId = $_REQUEST["id"]; else $getmemberId = $_SESSION["memberid"]; //$x = getTableDetailsByTableName1(""); // echo count($site["tablename"]); $zz=-1; for($ww=0;$ww<count($site["tablename"]);$ww++) { $ValidTable = array("baltperm4w", "balt_yellowpages","boats"); if(!in_array($site["tablename"][$ww],$ValidTable)) { if (count(getTableDetailsByTableName2($site["tablename"][$ww])) >0) $zz++; for($kk=0;$kk<count(getTableDetailsByTableName2($site["tablename"][$ww]));$kk++) { // echo $site["tablename"][$zz]."<br></br>"; $getTableDetails = getTableDetailsByTableName($site["tablename"][$ww],$kk); //echo $getTableDetails["city"]; if ($kk > 0) if ($getTableDetails['city']==$lastcity && $getTableDetails['state']==$laststate) { continue; } $getAllArray[$zz][$kk]["Titlename"] = "<a href='http://www.listrave.com'>ListRave</a> --> <a href=".$getTableDetails["stateurl"].">".$getTableDetails["state"]."</a> --> <a href=".$getTableDetails["cityurl"].">".mysql_real_escape_string($getTableDetails["city"])."</a> --> <a href=".$getTableDetails["maincaturl"].">".$getTableDetails["maincat"]."</a> --> <a href=".$getTableDetails["caturl"].">".$getTableDetails["cat"]."</a>"; $getAllArray[$zz][$kk]["PostURL"] = $getTableDetails["SitePostUrl"]; $getAllArray[$zz][$kk]["AgeFormat"] = $getTableDetails["DisplayFormat"]; $getAllArray[$zz][$kk]["TableName"] = $site["tablename"][$ww]; $getAllArray[$zz][$kk]["SiteRealPath"] = $getTableDetails["SiteRealPath"]; $lastcity = $getTableDetails["city"]; $laststate = $getTableDetails["state"]; $GetAdlists[$zz]["MainArray"] = GetMemberAdLists($site["tablename"][$ww],$getmemberId); if($GetAdlists[$zz]["MainArray"]!=""){ $getAllArray[$zz][$kk]["ArrayExist"] = "Yes"; }else{ $getAllArray[$zz][$kk]["ArrayExist"] = "No"; } for($k=0;$k<count($GetAdlists[$zz]["MainArray"]);$k++) { $getdate = explode(",",$GetAdlists[$zz]["MainArray"][$k]["Posted_date"]); $getAllArray[$zz][$kk][$k]['day'] = date("l",strtotime($getdate[0])); $getAllArray[$zz][$kk][$k]['month'] = date("F",strtotime($getdate[0])); $getAllArray[$zz][$kk][$k]['date'] = date("d",strtotime($getdate[0])); $getAllArray[$zz][$kk][$k]['ListArray'] = getMemberAddetails($getdate[0],$site["tablename"][$ww],$getmemberId, $getTableDetails["city"], $getTableDetails["state"]); for($mn=0;$mn<count($getAllArray[$zz][$kk][$k]['ListArray']);$mn++) { if($getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture0"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture1"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture2"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture3"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture4"]!='' || $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["Picture5"]!='') $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["ImageArray"] = 'Yes'; else $getAllArray[$zz][$kk][$k]['ListArray'][$mn]["ImageArray"] = 'No'; } } } } } /* if($_SERVER['REMOTE_ADDR'] = '122.165.56.46') { printArray($getAllArray); exit; } */ function SelectQry1($Qry) { $result = mysql_query($Qry) or die ("QUERY Error:".$Qry."<br>".mysql_error()); $numrows = mysql_num_rows($result); if ($numrows == 0){ return; } else { $row = array(); $record = array(); while ($row = mysql_fetch_array($result)){ $record[] = $row; } } return $record; } function getTableDetailsByTableName($tablename, $kk) { global $global_config; $Qry = "select * FROM ".$tablename.""; $getListingdetail = SelectQry1($Qry); return $getListingdetail[$kk]; } function getTableDetailsByTableName2($tablename) { global $global_config; $Qry = "select * FROM ".$tablename.""; $getListingdetail = SelectQry1($Qry); return $getListingdetail; } function GetMemberAdLists($tablename,$getmemberId) { global $global_config; $Qry = "select Posted_date FROM ".$tablename." where memberid='".$getmemberId."' group by SUBSTRING_INDEX(Posted_date,',',1) Order by Posted_date DESC"; $getimagedetail = SelectQry1($Qry); return $getimagedetail; } function getMemberAddetails($date,$tablename,$getmemberId) { global $global_config; $Qry = "select * from ".$tablename." WHERE `Posted_date` like '%".$date."%' AND ActivationStatus = 'Active' AND PublishedStatus='Active' AND memberid='".$getmemberId."' group by Posted_date Order by Ident DESC"; $getimagedetail = SelectQry1($Qry); return $getimagedetail; } ?> Here's the code to display it. Remember, this is just for "Frickster's ListRave Posts" <?php // start session ob_start(); session_start(); include "../includes/config.php"; //include('incsec/inccheckifadmin.php'); include ('incsec/incconn.php'); include ('incsec/incsettings.php'); include ('incfunctions.php'); if($_REQUEST["id"]!='') $ActiveMemberID = $_REQUEST["id"]; else $ActiveMemberID = $_SESSION["memberid"]; $query="SELECT * FROM tblmembers where memberid = '".$ActiveMemberID."'"; $result11 = mysql_query($query,$dbconnection); $members = mysql_fetch_array($result11); $pagetitle = 'ListRave - '.$members["username"]." 's".' Profile Page'; include("memberall_business.php"); include('memberall_listings.php'); //printArray($getAllArray); //exit; ?> <?php include('header_member2.php') ?> <div style="height:50px;"> </div> <table border="0" cellpadding="2" cellspacing="0" width="80%" align="center"> <tr> <td valign="top" width="30%" align="left"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td valign="top" align="left"> <table width="100%"> <tr> <td valign = "top" style="text-align: center;"> <?php include ('incsec/incconn.php'); $dbconnection = mysql_connect($dbhost,$dbusername,$dbpassword); mysql_select_db($database,$dbconnection); $query="SELECT * FROM tblmembers where memberid = '".$ActiveMemberID."'"; $result = mysql_query($query,$dbconnection); $numrecs=mysql_num_rows($result); $myrow = mysql_fetch_array($result); $currentmemberid = $myrow['memberid']; $qry="SELECT * FROM tbl_listrave_ad where memberid = '".$ActiveMemberID."' and PublishedStatus='Active'"; $result1 = mysql_query($qry,$dbconnection); $getcnt =mysql_num_rows($result1); ?> <?php if($numrecs!=0) { ?> <table height="100" width="90%" border="0" cellpadding="6" cellspacing="0" align="center"> <tr> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="border:1px solid #0166FF;"> <tr> <td align="left" class="profilefheader" width="100%" colspan="2" style="padding-left:5px; padding-top:0px; height:20px; line-height:20px;" valign="middle"><?php echo $myrow["username"]; ?>'s Profile</td> </tr> <tr> <td align="left" valign="top"> <table width="100%" border="0" cellpadding="10" cellspacing="0" id="profilecontainer" align="left" style="margin-left: 10%"> <tr> <td valign = "top" width="10%"> <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center"> <tr> <td width="20%" align="left" valign="top" style="padding-right:35px"> <?php if($myrow["memberphoto"]!='') { ?> <a target="_blank" href="imageview.php?id=<?php echo $myrow["memberid"]; ?>"> <img width="180" height="180" class="Imageborder" src="<?php echo $config["sitepath"]."memberphotos/".$myrow["memberphoto"].""; ?>"> </a> <?php } else { ?> <img src="no-image.gif" border="0" width="180" height="180" class="Imageborder" /> <?php } ?> </td> </tr> <tr> <td height="30"> </td> </tr> <?php /*?><tr> <td width="80%" align="center" valign="top"> <?php if($myrow["memberphoto"]!='') { ?> <img src="upload.gif" border="0" /> <?php } else { ?> <img src="change-photo.gif" border="0" /> <?php } ?> </td> </tr><?php */?><tr valign="bottom"><td> </td></tr><tr><td align="left"><img src="addcontact.gif" alt="Add This Member To Your Contacts" /></td></tr></table> </td> <td valign = "top"> <table width="90%" border="0" cellpadding="6" cellspacing="0" align="left"> <tr> <td align="left" valign="top" colspan="2"> <table width="90%" border="0" cellpadding="0" cellspacing="0"> <tr> <td valign="top" width="15%" nowrap="nowrap"> <span id="profilecontainer">Personal Information </span> </td> <td width="88%" valign="top"> <div style="border-top: #CCCCCC solid 1px; position:relative; top:7px;"> </div> </td> </tr> </table> </td> </tr> <?php if($myrow["firstname"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>First Name</strong> </td> <td align="left" valign="top"> <?php echo $myrow["firstname"]; ?> </td> </tr> <?php } ?> <?php if($myrow["othernames"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Last Name</strong> </td> <td align="left" valign="top"> <?php echo $myrow["othernames"]; ?> </td> </tr> <?php } ?> <?php if($myrow["gender"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Gender</strong> </td> <td align="left" valign="top"> <?php echo $myrow["gender"]; ?> </td> </tr> <?php } ?> <?php if($myrow["age"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Age</strong> </td> <td align="left" valign="top"> <?php echo $myrow["age"]; ?> </td> </tr> <?php } ?> <?php if($myrow["pobox"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Location</strong> </td> <td align="left" valign="top"> <?php echo $myrow["pobox"]; ?> </td> </tr> <?php } ?> <?php if($myrow["relationship_status"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Relationship Status</strong> </td> <td align="left" valign="top"> <?php echo $myrow["relationship_status"]; ?> </td> </tr> <?php } ?> <?php if($myrow["registrationdate"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Member Since</strong> </td> <td align="left" valign="top"> <?php echo date('M d, Y', strtotime($myrow["registrationdate"])); ?> </td> </tr> <?php } ?> <?php if($myrow["username"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>User Name</strong> </td> <td align="left" valign="top"> <?php echo $myrow["username"]; ?> </td> </tr> <?php } ?> <?php if($myrow["about_me"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>About me</strong> </td> <td align="left" valign="top" style="padding-right:80px"> <?php echo $myrow["about_me"]; ?> </td> </tr> <?php } ?> <?php if($myrow["hobbies"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Hobbies</strong> </td> <td align="left" valign="top" style="padding-right:80px"> <?php echo $myrow["hobbies"]; ?> </td> </tr> <?php } ?> <?php if($myrow["movies"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Favorite Movies</strong> </td> <td align="left" valign="top" style="padding-right:80px"> <?php echo $myrow["movies"]; ?> </td> </tr> <?php } ?> <?php if($myrow["music"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Favorite Music</strong> </td> <td align="left" valign="top" style="padding-right:80px"> <?php echo $myrow["music"]; ?> </td> </tr> <?php } ?> <?php if($myrow["books"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Favorite Books</strong> </td> <td align="left" valign="top" style="padding-right:80px"> <?php echo $myrow["books"]; ?> </td> </tr> <?php } ?> <tr> <td height="15"> </td> </tr> <tr> <td align="left" valign="top" colspan="2"> <table width="90%" border="0" cellpadding="0" cellspacing="0" > <tr> <td valign="top" width="15%" nowrap="nowrap" > <span id="profilecontainer">Contact Information </span> </td> <td width="88%" valign="top"> <div style="border-top: #CCCCCC solid 1px; position:relative; top:7px;"> </div> </td> </tr> </table> </td> </tr> <?php if($myrow["emailaddress"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Email</strong> </td> <td align="left" valign="top"> <?php echo $myrow["emailaddress"]; ?> </td> </tr> <?php } ?> <?php if($myrow["phonenumber"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Mobile Number</strong> </td> <td align="left" valign="top"> <?php echo $myrow["phonenumber"]; ?> </td> </tr> <?php } ?> <?php /*?><?php if($myrow["town"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>City</strong> </td> <td align="left" valign="top"> <?php echo $myrow["town"]; ?> </td> </tr> <?php } ?><?php */?> <?php /*?><?php if($myrow["postcode"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Post Code</strong> </td> <td align="left" valign="top"> <?php echo $myrow["postcode"]; ?> </td> </tr> <?php } ?><?php */?> <tr> <td height="15"> </td> </tr> <?php if($myrow["companyname"]!='' || $myrow["memberwebsite"]!='') { ?> <tr> <td align="left" valign="top" colspan="2"> <table width="90%" border="0" cellpadding="0" cellspacing="0" > <tr> <td valign="top" width="13%" nowrap="nowrap" > <span id="profilecontainer">Work Information </span> </td> <td width="88%" valign="top"> <div style="border-top: #CCCCCC solid 1px; position:relative; top:7px;"> </div> </td> </tr> </table> </td> </tr> <?php if($myrow["companyname"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Company Name</strong> </td> <td align="left" valign="top"> <?php echo $myrow["companyname"]; ?> </td> </tr> <?php } ?> <?php if($myrow["memberwebsite"]!='') { ?> <tr> <td width="20%" align="left" valign="top"> <strong>Website</strong> </td> <td align="left" valign="top"> <? $gethttp = substr_count($myrow["memberwebsite"], 'http://'); if($gethttp!=0) $websitelink = $myrow["memberwebsite"]; else $websitelink = "http://".$myrow["memberwebsite"]; ?> <a href="<?php echo $websitelink ?>" target="_blank"><?php echo $websitelink; ?></a> </td> </tr> <?php } ?> <?php } ?> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> <div style="height:20px;"> </div> <table width="85%" border="0" cellpadding="2" cellspacing="5" align="center"> <tr> <td class="profilefheader33" width="85%" colspan="2" style="padding-left:5px; padding-top:0px; height:20px; line-height:20px;" valign="middle; text-align:left"><?php echo $myrow["username"]; ?>'s ListRave Posts</td> </tr> <tr> <td valign="top" height="20"> </td> </tr> <?php $flag =0; for($jj=0;$jj<count($getAllArray);$jj++) for($kk=0;$kk<count($getAllArray[$jj]);$kk++) { ?> <?php if($getAllArray[$jj][$kk]["ArrayExist"]=='Yes'&& $getAllArray[$jj][$kk]["PostURL"]!='') { $flag =1; ?> <?php if($getAllArray[$jj][$kk]["Titlename"]!='') { ?> <tr> <td valign="top" style="padding-left:10px; color:#0066ff; font-size:12px;font-style: italic;padding-bottom:-3em;text-align:left"> <b><?php echo stripslashes($getAllArray[$jj][$kk]["Titlename"]); ?></b> </td> </tr> <?php } ?> <tr> <td valign="top" style="padding-left:10px;"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <?php for($mn=0;$mn<count($getAllArray[$jj][$kk]);$mn++) { if ($getAllArray[$jj][$kk][$mn]['ListArray'] == "") continue; ?> <?php $getdate = substr($getAllArray[$jj][$kk][$mn]["date"], 0, 1); if($getdate==0) $date = str_replace("0","",$getAllArray[$jj][$kk][$mn]["date"]); else $date = $getAllArray[$jj][$kk][$mn]["date"]; ?> <tr> <td valign="top" style="padding-left:20px;padding-top:0px;text-align:left;"> <table border="0" cellpadding="5" cellspacing="5" width="100%"> <?php if($getAllArray[$jj][$kk][$mn]["day"]!='') { ?> <tr> <td valign="top" colspan="3"> <div style="height:15;margin-bottom:-.5em"> <b style="font-size:13px;margin-bottom:-.4em"> <?php echo $getAllArray[$jj][$kk][$mn]["day"]?>, <?php echo $getAllArray[$jj][$kk][$mn]["month"]; ?> <?php echo $date; ?><?php if($getAllArray[$jj][$kk][$mn]["date"]=='01' || $getAllArray[$jj][$kk][$mn]["date"]=='1' || $getAllArray[$jj][$kk][$mn]["date"]=='31' || $getAllArray[$jj][$kk][$mn]["date"]=='21') { ?>st. <?php } elseif($getAllArray[$jj][$kk][$mn]["date"]=='02' || $getAllArray[$jj][$kk][$mn]["date"]=='2' || $getAllArray[$jj][$kk][$mn]["date"]=='22') { ?>nd.<?php } elseif($getAllArray[$jj][$kk][$mn]["date"]=='03' || $getAllArray[$jj][$kk][$mn]["date"]=='3') { ?>rd.<?php } else { ?>th.<?php } ?> </b> </div> </td> </tr> <tr> <td colspan="3" height="5" > <hr style="height:5px; color: #0066ff; background: #0066ff; margin-top: -.4em; margin-bottom:-.4em" /> </td> </tr> <?php } ?> <?php for($zz=0;$zz<count($getAllArray[$jj][$kk][$mn]["ListArray"]);$zz++) { ?> <tr> <td valign="top" > <b style="color:#0066ff; font-size: 11px"><a href="<?php echo $getAllArray[$jj][$kk]["PostURL"].$getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Title"]; ?>"><?php echo substr($getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Original_Title"],0,60); ?> </a> <b style="color:#0066ff; font-style:italic; font-size: 10px">- <?php if($getAllArray[$jj][$kk]["AgeFormat"]=='Price') { ?> <? if($getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Age"]!='' && $getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Age"]!='0') { $dollarexists = substr_count($getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Age"],'$'); if($dollarexists!='1') { $price = str_replace(",","",$getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Age"]); ?> $<?php echo number_format($price,2); ?> <?php } else { $price = explode("$",$getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Age"]); ?> $<?php $price1 = str_replace(",","",$price[1]); echo number_format($price1,2); ?> <?php } } ?> <?php } else { ?> <?php echo $getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Age"]; } ?> </b> </span><b style="font-size: 10px; color:black"><em>(<?php echo $getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["Location"]; ?>)</em></b><?php if($getAllArray[$jj][$kk][$mn]["ListArray"][$zz]["ImageArray"]=='Yes') { ?>- <span><img src="camera.gif" height="15px" width="15px" /></span><?php } ?> </td> </tr> <?php } ?> </table> </td> </tr> <?php } ?> </table> </td> </tr> <tr> <td height="15"> </td> </tr> <?php } } ?> <?php if($flag==0) { ?> <tr> <td align="center"><span style="color:#FF0000;font-size:16px;font-family:Arial, Helvetica, sans-serif;font-weight:bold;">No Current ListRave Ad(s)</td> </tr> <?php } ?> </table> <table border="0" cellpadding="2" cellspacing="2" width="85%" align="center"> <tr> <td class="profilefheader33" width="85%" colspan="2" style="padding-left:5px; margin-bottom:-3em;padding-top:0px; height:20px; line-height:20px;" valign="middle"><?php echo $myrow["username"]; ?>'s Business Listings</td> </tr> <tr> <td valign="top" height="20" style="margin-bottom:-3em"> </td> </tr> <?php $flag = 0; for($k=0;$k<count($getmemberBusiness);$k++) { if($getmemberBusiness[$k]["ArrayExist"]=='Yes') { $flag =1; ?> <?php if($getmemberBusiness[$k]["Titlename"]!='') { ?> <tr> <td valign="top" style="padding-left:10px; color:#0066ff; font-size:12px; font-style: italic;font-family:Verdana;padding-top:20px;text-align:left"> <b><?php echo ucwords($getmemberBusiness[$k]["Titlename"]); ?></b> </td> </tr> <?php } ?> <td valign="top" style="padding-left:10px;"> <?php for($m=0;$m<count($getmemberBusiness[$k]["BusinessArray"]);$m++) { ?> <table border="0" cellpadding="5" cellspacing="5" width="100%" align="center"> <tr> <td valign="top" style="padding-left:30px; color:#000000; font-size:14px; width="60%;"> <div style="height:8;text-align:left"> <b style="font-size:13px;text-align:left"> <?php $datetime = explode("-",$getmemberBusiness[$k]["BusinessArray"][$m]["AddedDate"]); $month = date("F",strtotime($getmemberBusiness[$k]["BusinessArray"][$m]["AddedDate"])); $day = date("l",strtotime($getmemberBusiness[$k]["BusinessArray"][$m]["AddedDate"])); $year = date("Y",strtotime($getmemberBusiness[$k]["BusinessArray"][$m]["AddedDate"])); ?> <?php $getdate = substr($datetime[2], 0, 1); if($getdate==0) $date = str_replace("0","",$datetime[2]); else $date = $datetime[2]; ?> <?php echo $day; ?>, <?php echo $month; ?> <?php echo $date; ?><?php if($datetime[2]=='01' || $datetime[2]=='1' || $datetime[2]=='21' || $datetime[2]=='31') { ?>st. <?php } elseif($datetime[2]=='02' || $datetime[2]=='2') { ?>nd.<?php } elseif($datetime[2]=='03' || $datetime[2]=='3') { ?>rd.<?php } else { ?>th.<?php } ?> <?php echo $year; ?> </b> </div> </td> </tr> <tr> <td colspan="3" height="5" style="padding-left:30px"> <hr style="height:5px; color: #0066ff; background: #0066ff; margin-top: -.4em;" /> </td> </tr> <?php for($z=0;$z<count($getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"]);$z++) { ?> <tr> <td valign="top" style="padding-left:30px;text-align:left" width="100%;"> <b style="color:#0066ff; font-size: 11px;"> <?php echo ucwords($getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["BusinessName"]); ?><span style="padding-left:15px;color:#383838"><?php echo $getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["Address"]; ?> <?php echo $getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["City"]; ?>, <?php echo $getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["State"]; ?> <?php echo $getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["ZipCode"]; ?> <?php if($getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["AreaCode"]!='') { ?>(<?php echo $getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["AreaCode"]; ?>) <?php } ?> <?php echo substr($getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["Telephone"], 0, 3); ?>-<?php echo substr($getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"][$z]["Telephone"], 3, 4); ?></span> </b> </td> </tr> <?php } ?> </table> <?php } } } ?> <?php if($flag==0) { ?> <tr> <td align="center"><span style="color:#FF0000;font-size:16px;font-family:Arial, Helvetica, sans-serif;font-weight:bold;">No Current Business Listings</span></td> </tr> <?php } ?> <tr> <td align="center"></td> </tr> </table> </form> <?php } else { ?> <?php } ?> </td> </tr> </table> </td> </tr> </table> <div style="height:150px;"> </div> <?php include('footer_member.php') ?> Any ideas? Dennis Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.