Need help with this one php file - Driving me crazy

$frickfrack$ · 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') ?>

<tr>

<tr>

<tr>

<?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) { ?>

<tr>

<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>

<tr>

<tr>

<?php if($myrow["memberphoto"]!='') { ?>

</a>

<?php } else { ?>

<?php } ?>

</td>

</tr>

<tr>

</td>

</tr>

<?php /*?><tr>

<?php if($myrow["memberphoto"]!='') { ?>

<?php } else { ?>

<?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>

<tr>

<tr>

<span id="profilecontainer">Personal Information </span>

</td>

</td>

</tr>

</table>

</td>

</tr>

<?php if($myrow["firstname"]!='') { ?>

<tr>

<strong>First Name</strong>

</td>

<?php echo $myrow["firstname"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["othernames"]!='') { ?>

<tr>

</td>

<?php echo $myrow["othernames"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["gender"]!='') { ?>

<tr>

<strong>Gender</strong>

</td>

<?php echo $myrow["gender"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["age"]!='') { ?>

<tr>

</td>

<?php echo $myrow["age"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["pobox"]!='') { ?>

<tr>

<strong>Location</strong>

</td>

<?php echo $myrow["pobox"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["relationship_status"]!='') { ?>

<tr>

<strong>Relationship Status</strong>

</td>

<?php echo $myrow["relationship_status"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["registrationdate"]!='') { ?>

<tr>

<strong>Member Since</strong>

</td>

<?php echo date('M d, Y', strtotime($myrow["registrationdate"])); ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["username"]!='') { ?>

<tr>

</td>

<?php echo $myrow["username"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["about_me"]!='') { ?>

<tr>

<strong>About me</strong>

</td>

<?php echo $myrow["about_me"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["hobbies"]!='') { ?>

<tr>

<strong>Hobbies</strong>

</td>

<?php echo $myrow["hobbies"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["movies"]!='') { ?>

<tr>

<strong>Favorite Movies</strong>

</td>

<?php echo $myrow["movies"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["music"]!='') { ?>

<tr>

<strong>Favorite Music</strong>

</td>

<?php echo $myrow["music"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["books"]!='') { ?>

<tr>

<strong>Favorite Books</strong>

</td>

<?php echo $myrow["books"]; ?>

</td>

</tr>

<?php } ?>

<tr>

</td>

</tr>

<tr>

<tr>

<span id="profilecontainer">Contact Information </span>

</td>

</td>

</tr>

</table>

</td>

</tr>

<?php if($myrow["emailaddress"]!='') { ?>

<tr>

<strong>Email</strong>

</td>

<?php echo $myrow["emailaddress"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["phonenumber"]!='') { ?>

<tr>

<strong>Mobile Number</strong>

</td>

<?php echo $myrow["phonenumber"]; ?>

</td>

</tr>

<?php } ?>

<?php /*?><?php if($myrow["town"]!='') { ?>

<tr>

</td>

<?php echo $myrow["town"]; ?>

</td>

</tr>

<?php } ?><?php */?>

<?php /*?><?php if($myrow["postcode"]!='') { ?>

<tr>

</td>

<?php echo $myrow["postcode"]; ?>

</td>

</tr>

<?php } ?><?php */?>

<tr>

</td>

</tr>

<?php if($myrow["companyname"]!='' || $myrow["memberwebsite"]!='') { ?>

<tr>

<tr>

<span id="profilecontainer">Work Information </span>

</td>

</td>

</tr>

</table>

</td>

</tr>

<?php if($myrow["companyname"]!='') { ?>

<tr>

<strong>Company Name</strong>

</td>

<?php echo $myrow["companyname"]; ?>

</td>

</tr>

<?php } ?>

<?php if($myrow["memberwebsite"]!='') { ?>

<tr>

<strong>Website</strong>

</td>

<?

$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 } ?>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</div>

<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>

</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>

</tr>

<?php } ?>

<tr>

<?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>

<?php if($getAllArray[$jj][$kk][$mn]["day"]!='') { ?>

<tr>

<?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>

</tr>

<?php } ?>

<?php for($zz=0;$zz<count($getAllArray[$jj][$kk][$mn]["ListArray"]);$zz++) { ?>

<tr>

<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>

</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>

<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>

</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>

</tr>

<?php } ?>

<?php for($m=0;$m<count($getmemberBusiness[$k]["BusinessArray"]);$m++) { ?>

<tr>

<?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>

</tr>

<?php for($z=0;$z<count($getmemberBusiness[$k]["BusinessArray"][$m]["BusinessLists"]);$z++) { ?>

<tr>

<?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>

</tr>

</table>

</form>

<?php } else { ?>

<?php

} ?>

</td>

</tr>

</table>

</td>

</tr>

</table>

</div>

<?php include('footer_member.php') ?>

Any ideas?

Dennis

Sign In

Need help with this one php file - Driving me crazy

Recommended Posts

frickfrack

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information