a search problem

General PHP Help
#1

Hi there,
Ive got a rental listing website slowly being made, and have come into a problem with it. I have different price ranges that are being offered with two of them making the ad on search.php bold and highlighted, how ever its only excuting half the script and not working out the PriorityLevel on the second statement and showing all results the same.
Here is the code

[code]<?
require_once(“conn.php”);
require_once(“includes.php”);
if(!isset($_GET[‘page’])){
$page = 1;
} else {
$page = $_GET[‘page’];
}
$max_results = 10;
$from = (($page * $max_results) - $max_results);
$query = array();

if(!empty($_GET[c]))
{
$query[] = "re_listings.CategoryID = ‘$_GET[c]’ ";
}

if(!empty($_GET[s]))
{
$query[] = "re_listings.SubcategoryID = ‘$_GET[s]’ ";
}

if(!empty($_GET[AgentID]))
{
$query[] = "re_listings.AgentID = ‘$_GET[AgentID]’ ";
}

if(!empty($_GET[search_country]))
{
$query[] = "re_listings.country = ‘$_GET[search_country]’ ";
}

if(!empty($_GET[search_state]))
{
$query[] = "re_listings.state = ‘$_GET[search_state]’ ";
}

if(!empty($_GET[search_city]))
{
$query[] = "re_listings.city = ‘$_GET[search_city]’ ";
}

if(!empty($_GET[search_PropertyType]))
{
$query[] = "re_listings.PropertyType = ‘$_GET[search_PropertyType]’ ";
}

if(!empty($_GET[MinPriceW]))
{
$query[] = "re_listings.price >= ‘$_GET[MinPriceW]’ ";
}

if(!empty($_GET[MaxPriceW]))
{
$query[] = "re_listings.price <= ‘$_GET[MaxPriceW]’ ";
}

if(!empty($_GET[MinPriceSp]))
{
$query[] = "re_listings.price >= ‘$_GET[MinPriceSp]’ ";
}

if(!empty($_GET[MaxPriceSp]))
{
$query[] = "re_listings.price <= ‘$_GET[MaxPriceSp]’ ";
}

if(!empty($_GET[MinPriceSu]))
{
$query[] = "re_listings.price >= ‘$_GET[MinPriceSu]’ ";
}

if(!empty($_GET[MaxPriceSu]))
{
$query[] = "re_listings.price <= ‘$_GET[MaxPriceSu]’ ";
}

if(!empty($_GET[MinPriceA]))
{
$query[] = "re_listings.price >= ‘$_GET[MinPriceA]’ ";
}

if(!empty($_GET[MaxPriceA]))
{
$query[] = "re_listings.price <= ‘$_GET[MaxPriceA]’ ";
}

if(!empty($_GET[rooms1]))
{
$query[] = "re_listings.rooms >= ‘$_GET[rooms1]’ ";
}

if(!empty($_GET[rooms2]))
{
$query[] = "re_listings.rooms <= ‘$_GET[rooms2]’ ";
}

if(!empty($_GET[bath1]))
{
$query[] = "re_listings.bathrooms >= ‘$_GET[bath1]’ ";
}

if(!empty($_GET[bath2]))
{
$query[] = "re_listings.bathrooms <= ‘$_GET[bath2]’ ";
}

if(!empty($_GET[before]))
{
$MyDate = strtotime("-$_GET[before]");
$query[] = "re_listings.DateAdded >= ‘$MyDate’ ";
}

if(!empty($_GET[school]))
{
$query[] = "re_listings.NearSchool = ‘y’ ";
}

if(!empty($_GET[transit]))
{
$query[] = "re_listings.NearTransit = ‘y’ ";
}

if(!empty($_GET[park]))
{
$query[] = "re_listings.NearPark = ‘y’ ";
}

if(!empty($_GET[ocean_view]))
{
$query[] = "re_listings.OceanView = ‘y’ ";
}

if(!empty($_GET[lake_view]))
{
$query[] = "re_listings.LakeView = ‘y’ ";
}

if(!empty($_GET[mountain_view]))
{
$query[] = "re_listings.MountainView = ‘y’ ";
}

if(!empty($_GET[ocean_waterfront]))
{
$query[] = "re_listings.OceanWaterfront = ‘y’ ";
}

if(!empty($_GET[lake_waterfront]))
{
$query[] = "re_listings.LakeWaterfront = ‘y’ ";
}

if(!empty($_GET[river_waterfront]))
{
$query[] = "re_listings.RiverWaterfront = ‘y’ ";
}

if(!empty($query))
{
$MyQuery = implode(" and ", $query);

$MyQuery = "and ".$MyQuery;
}

////////////////////////////////////////////////////////////
////////// order by

$order = array();

if(!empty($_GET[orderby]))
{
$MyOrder = explode("|", $_GET[orderby]);

while(list(,$ov) = each($MyOrder))
{
if($ov == “DateAdded”)
{
$order[] = " re_listings.DateAdded desc ";
}

  if($ov == "Price")
  {
     $order[] = " re_listings.Price asc ";
  }
  
  if($ov == "address")
  {
     $order[] = " re_listings.address asc ";
  }

}
}
else
{
if(!empty($_GET[p]))
{
$order[] = " re_listings.Price asc ";
}

if(!empty($_GET[r]))
{
$order[] = " re_listings.rooms asc, re_listings.bathrooms asc, re_listings.garage asc ";
}

if(!empty($_GET[city]))
{
$order[] = " re_listings.city, re_listings.address, re_listings.state ";
}

}

if(count($order) > ‘0’)
{
$MyOrder = implode(", ", $order);

}

if(empty($MyOrder))
{
$MyOrder = " order by re_agents.PriorityLevel desc, re_listings.DateAdded desc";
}
else
{
$MyOrder = " order by re_agents.PriorityLevel desc, $MyOrder";
}

if(!empty($_GET[Start]))
{
$Start = $_GET[Start];
}
else
{
$Start = ‘0’;
}

$ByPage = ‘2’;

if($aset[Sitefee]==“1”)
{
$q1 = “select * from re_listings, re_agents where re_listings.AgentID = re_agents.AgentID and re_agents.AccountStatus = ‘active’ $MyQuery $MyOrder limit $from, $max_results”;
$total_results = mysql_num_rows(mysql_query(“select * from re_listings, re_agents where re_listings.AgentID = re_agents.AgentID order by re_listings.DateAdded”));
//echo $total_results;
$total_pages = ceil($total_results / $max_results);
}
else
{
$q1 = “select * from re_listings, re_agents, re_priority where re_listings.AgentID = re_agents.AgentID and re_agents.PriorityLevel = re_priority.PriorityLevel and re_agents.AccountStatus = ‘active’ $MyQuery $MyOrder limit $from, $max_results”;
$total_results = mysql_num_rows(mysql_query(“select * from re_listings, re_agents, re_priority where re_listings.AgentID = re_agents.AgentID and re_agents.PriorityLevel = re_priority.PriorityLevel and re_agents.AccountStatus = ‘active’ $MyQuery $MyOrder”));
//echo $total_results;
$total_pages = ceil($total_results / $max_results);

  }

$qnav = “select * from re_listings, re_agents where re_listings.AgentID = re_agents.AgentID $MyQuery”;

$r1 = mysql_query($q1) or die(mysql_error());
$lrows = mysql_num_rows($r1);

$q2 = "select * from re_agents, re_listings where re_listings.ListingID = ‘$_GET[id]’ and re_listings.AgentID = re_agents.AgentID ";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);

if ($a2[PriorityLevel]=1)
{
$ListingTable .= “
”;

if($lrows > '0')

{

$ListingTable .= “

n”;

while($a1 = mysql_fetch_array($r1))
{

  	$ListingTable .= "<tr style="border-width:1;border-color:blue" onMouseOver="this.style.background='#ffffff'; this.style.cursor='hand'" onMouseOut="this.style.background='images/search_bg.gif'" onClick="window.open('info.php?id=$a1[ListingID]', '_top')">nt";
  $ListingTable .= "<td height=60>";

  $ListingTable .= "<table align=center width="100%">n";

if($aset[Sitefee]==“0”)
{
$ListingTable .= “$a1[rooms] bed-roomed $a1[PropertyType] in $a1[city], $a1[country]. Sleeps $a1[sleeps].n”;
}

  $ListingTable .= "<tr>nt<td width=75>";

  if(!empty($a1[image]))
  {
     $images = explode("|", $a1[image]);
     $MyImage = $images[0];

     $ListingTable .= "<img src="re_images/$MyImage" width=75 height=60 border=1>";
  }
  else
  {
     $ListingTable .= "<img src="no_image.gif" border=1>";
  }

  $ListingTable .= "</td>nt";

  $ListingTable .= "<td width=225 valign=top><b>Property ID: $a1[ListingID]</b><br>$a1[address], $a1[city]<br>$a1[state], $a1[country]</td>nt";
  $ListingTable .= "<td width=100 valign=top>$a1[rooms] Bedroom(s),<br> $a1[bathrooms] bathroom(s)";

  $min1 = $a1[MinPriceW];
  $min2 = $a1[MinPriceSp];
  $min3 = $a1[MinPriceA];
  $min4 = $a1[MinPriceSu];
  $divide = 4;
  $max1 = $a1[MaxPriceW];
  $max2 = $a1[MaxPriceSp];
  $max3 = $a1[MaxPriceA];
  $max4 = $a1[MaxPriceSu];
  $r_minprice = ($min1 + $min2 + $min3 + $min4) / $divide;
  $r_maxprice = ($max1 + $max2 + $max3 + $max4) / $divide;
  $MyPrice = number_format($r_minprice, 2, ".", ",");
  $MyPrice2 = number_format($r_maxprice, 2, ".", ",");

  $ListingTable .= "<br><strong>Price Range:</strong> $aset[Currencya]$MyPrice - $aset[Currencya]$MyPrice2 pw<br />n";
  
  $ListingTable .= "</tr>n";

  $ListingTable .= "<tr>nt<td colspan=4>$a1[ShortDesc]</td>n</tr>n";

  $ListingTable .= "</table>nn</td>n</tr>nn";

}

$ListingTable .= “

”; 
  $rnav = mysql_query($qnav) or die(mysql_error());
  $rows = mysql_num_rows($rnav);

     if($rows > $ByPage)
     {
        $ListingTable .=  "<br><table align=center width=100%>";
        $ListingTable .= "<td align=center><font face=verdana size=2> ";

        $pages = ceil($rows/$ByPage);

        for($i = 0; $i <= ($pages); $i++)
        {
           $PageStart = $ByPage*$i;

           $i2 = $i + 1;

           if($PageStart == $Start)
           {
              $links[] = " <span class=RedLink>$i2</span>nt ";
           }
           elseif($PageStart < $rows)
           {
              $links[] = " <a class=BlackLink href="search.php?Start=$PageStart&c=$_GET[c]&s=$_GET[s]&AgentID=$_GET[AgentID]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_PropertyType=$_GET[search_PropertyType]&MinPrice=$_GET[MinPrice]&MaxPrice=$_GET[MaxPrice]&rooms1=$_GET[rooms1]&rooms2=$_GET[rooms2]&bath1=$_GET[bath1]&bath2=$_GET[bath2]&before=$_GET[before]&school=$_GET[school]&transit=$_GET[transit]&park=$_GET[park]&ocean_view=$_GET[ocean_view]&lake_view=$_GET[lake_view]&mountain_view=$_GET[mountain_view]&ocean_waterfront=$_GET[ocean_waterfront]&lake_waterfront=$_GET[lake_waterfront]&river_waterfront=$_GET[river_waterfront]&city=$_GET[city]&p=$_GET[p]&r=$_GET[r]">$i2</a>nt ";  
           }
        }

        //$links2 = implode(" | ", $links);
  
        //$ListingTable .= $links2;

        $ListingTable .= " </td>";

        $ListingTable .= "</table><br>n";

     }

}
}

// --------------------------------------------- PRIORITY CHANGE ---------------------------------------//

elseif ($a2[PriorityLevel]>=3)
{
$ListingTable = “
”;

    	if($lrows > '0')

{
$ListingTable .= “

n”;

while($a1 = mysql_fetch_array($r1))
{

  	$ListingTable .= "<tr style="border-width:1;border-color:blue" onMouseOver="this.style.background='#ffffff'; this.style.cursor='hand'" onMouseOut="this.style.background='#76cbeb'" onClick="window.open('info.php?id=$a1[ListingID]', '_top')">nt";
  $ListingTable .= "<td height=60>";

  $ListingTable .= "<table align=center width="100%">n";

if($aset[Sitefee]==“0”)
{
$ListingTable .= “$a1[rooms] bed-roomed $a1[PropertyType] in $a1[city], $a1[country]. Sleeps $a1[sleeps].n”;
}

  $ListingTable .= "<tr>nt<td width=75>";

  if(!empty($a1[image]))
  {
     $images = explode("|", $a1[image]);
     $MyImage = $images[0];

     $ListingTable .= "<img src="re_images/$MyImage" width=75 height=60 border=1>";
  }
  else
  {
     $ListingTable .= "<img src="no_image.gif" border=1>";
  }

  $ListingTable .= "</td>nt";

  $ListingTable .= "<td width=225 valign=top><b>Property ID: $a1[ListingID]</b><br>$a1[address], $a1[city]<br>$a1[state], $a1[country]</td>nt";
  $ListingTable .= "<td width=100 valign=top>$a1[rooms] Bedroom(s),<br> $a1[bathrooms] bathroom(s)";

  $min1 = $a1[MinPriceW];
  $min2 = $a1[MinPriceSp];
  $min3 = $a1[MinPriceA];
  $min4 = $a1[MinPriceSu];
  $divide = 4;
  $max1 = $a1[MaxPriceW];
  $max2 = $a1[MaxPriceSp];
  $max3 = $a1[MaxPriceA];
  $max4 = $a1[MaxPriceSu];
  $r_minprice = ($min1 + $min2 + $min3 + $min4) / $divide;
  $r_maxprice = ($max1 + $max2 + $max3 + $max4) / $divide;
  $MyPrice = number_format($r_minprice, 2, ".", ",");
  $MyPrice2 = number_format($r_maxprice, 2, ".", ",");

  $ListingTable .= "<br><strong>Price Range:</strong> $aset[Currencya]$MyPrice - $aset[Currencya]$MyPrice2 pw<br />n";

  $ListingTable .= "</tr>n";

  $ListingTable .= "<tr>nt<td colspan=4>$a1[ShortDesc]</td>n</tr>n";

  $ListingTable .= "</table>nn</td>n</tr>nn";

}

$ListingTable .= “

”; 
  $rnav = mysql_query($qnav) or die(mysql_error());
  $rows = mysql_num_rows($rnav);

     if($rows > $ByPage)
     {
        $ListingTable .=  "<br><table align=center width=100%>";
        $ListingTable .= "<td align=center><font face=verdana size=2> ";

        $pages = ceil($rows/$ByPage);

        for($i = 0; $i <= ($pages); $i++)
        {
           $PageStart = $ByPage*$i;

           $i2 = $i + 1;

           if($PageStart == $Start)
           {
              $links[] = " <span class=RedLink>$i2</span>nt ";
           }
           elseif($PageStart < $rows)
           {
              $links[] = " <a class=BlackLink href="search.php?Start=$PageStart&c=$_GET[c]&s=$_GET[s]&AgentID=$_GET[AgentID]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_PropertyType=$_GET[search_PropertyType]&MinPrice=$_GET[MinPrice]&MaxPrice=$_GET[MaxPrice]&rooms1=$_GET[rooms1]&rooms2=$_GET[rooms2]&bath1=$_GET[bath1]&bath2=$_GET[bath2]&before=$_GET[before]&school=$_GET[school]&transit=$_GET[transit]&park=$_GET[park]&ocean_view=$_GET[ocean_view]&lake_view=$_GET[lake_view]&mountain_view=$_GET[mountain_view]&ocean_waterfront=$_GET[ocean_waterfront]&lake_waterfront=$_GET[lake_waterfront]&river_waterfront=$_GET[river_waterfront]&city=$_GET[city]&p=$_GET[p]&r=$_GET[r]">$i2</a>nt ";
           }
        }

        //$links2 = implode(" | ", $links);

        //$ListingTable .= $links2;

        $ListingTable .= " </td>";

        $ListingTable .= "</table><br>n";

}
}
}
else
{
$ListingTable = “

No results were found!”;
}

require_once(“templates/HeaderTemplate.php”);
?>

<?
require_once(“templates/SearchTemplate.php”);
?>
<?
require_once(“templates/FooterTemplate.php”);

?>
[/code]

And this is the main part of where it decides on the PriorityLevel

[code]if ($a2[PriorityLevel]=1)
{
$ListingTable .= “
”;

if($lrows > '0')

{

$ListingTable .= “

n”;

while($a1 = mysql_fetch_array($r1))
{

  	$ListingTable .= "<tr style="border-width:1;border-color:blue" onMouseOver="this.style.background='#ffffff'; this.style.cursor='hand'" onMouseOut="this.style.background='images/search_bg.gif'" onClick="window.open('info.php?id=$a1[ListingID]', '_top')">nt";
  $ListingTable .= "<td height=60>";

  $ListingTable .= "<table align=center width="100%">n";

if($aset[Sitefee]==“0”)
{
$ListingTable .= “$a1[rooms] bed-roomed $a1[PropertyType] in $a1[city], $a1[country]. Sleeps $a1[sleeps].n”;
}

  $ListingTable .= "<tr>nt<td width=75>";

  if(!empty($a1[image]))
  {
     $images = explode("|", $a1[image]);
     $MyImage = $images[0];

     $ListingTable .= "<img src="re_images/$MyImage" width=75 height=60 border=1>";
  }
  else
  {
     $ListingTable .= "<img src="no_image.gif" border=1>";
  }

  $ListingTable .= "</td>nt";

  $ListingTable .= "<td width=225 valign=top><b>Property ID: $a1[ListingID]</b><br>$a1[address], $a1[city]<br>$a1[state], $a1[country]</td>nt";
  $ListingTable .= "<td width=100 valign=top>$a1[rooms] Bedroom(s),<br> $a1[bathrooms] bathroom(s)";

  $min1 = $a1[MinPriceW];
  $min2 = $a1[MinPriceSp];
  $min3 = $a1[MinPriceA];
  $min4 = $a1[MinPriceSu];
  $divide = 4;
  $max1 = $a1[MaxPriceW];
  $max2 = $a1[MaxPriceSp];
  $max3 = $a1[MaxPriceA];
  $max4 = $a1[MaxPriceSu];
  $r_minprice = ($min1 + $min2 + $min3 + $min4) / $divide;
  $r_maxprice = ($max1 + $max2 + $max3 + $max4) / $divide;
  $MyPrice = number_format($r_minprice, 2, ".", ",");
  $MyPrice2 = number_format($r_maxprice, 2, ".", ",");

  $ListingTable .= "<br><strong>Price Range:</strong> $aset[Currencya]$MyPrice - $aset[Currencya]$MyPrice2 pw<br />n";
  
  $ListingTable .= "</tr>n";

  $ListingTable .= "<tr>nt<td colspan=4>$a1[ShortDesc]</td>n</tr>n";

  $ListingTable .= "</table>nn</td>n</tr>nn";

}

$ListingTable .= “

”; 
  $rnav = mysql_query($qnav) or die(mysql_error());
  $rows = mysql_num_rows($rnav);

     if($rows > $ByPage)
     {
        $ListingTable .=  "<br><table align=center width=100%>";
        $ListingTable .= "<td align=center><font face=verdana size=2> ";

        $pages = ceil($rows/$ByPage);

        for($i = 0; $i <= ($pages); $i++)
        {
           $PageStart = $ByPage*$i;

           $i2 = $i + 1;

           if($PageStart == $Start)
           {
              $links[] = " <span class=RedLink>$i2</span>nt ";
           }
           elseif($PageStart < $rows)
           {
              $links[] = " <a class=BlackLink href="search.php?Start=$PageStart&c=$_GET[c]&s=$_GET[s]&AgentID=$_GET[AgentID]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_PropertyType=$_GET[search_PropertyType]&MinPrice=$_GET[MinPrice]&MaxPrice=$_GET[MaxPrice]&rooms1=$_GET[rooms1]&rooms2=$_GET[rooms2]&bath1=$_GET[bath1]&bath2=$_GET[bath2]&before=$_GET[before]&school=$_GET[school]&transit=$_GET[transit]&park=$_GET[park]&ocean_view=$_GET[ocean_view]&lake_view=$_GET[lake_view]&mountain_view=$_GET[mountain_view]&ocean_waterfront=$_GET[ocean_waterfront]&lake_waterfront=$_GET[lake_waterfront]&river_waterfront=$_GET[river_waterfront]&city=$_GET[city]&p=$_GET[p]&r=$_GET[r]">$i2</a>nt ";  
           }
        }

        //$links2 = implode(" | ", $links);
  
        //$ListingTable .= $links2;

        $ListingTable .= " </td>";

        $ListingTable .= "</table><br>n";

     }

}
}

// --------------------------------------------- PRIORITY CHANGE ---------------------------------------//

elseif ($a2[PriorityLevel]>=3)
{
$ListingTable = “
”;

    	if($lrows > '0')

{
$ListingTable .= “

n”;

while($a1 = mysql_fetch_array($r1))
{

  	$ListingTable .= "<tr style="border-width:1;border-color:blue" onMouseOver="this.style.background='#ffffff'; this.style.cursor='hand'" onMouseOut="this.style.background='#76cbeb'" onClick="window.open('info.php?id=$a1[ListingID]', '_top')">nt";
  $ListingTable .= "<td height=60>";

  $ListingTable .= "<table align=center width="100%">n";

if($aset[Sitefee]==“0”)
{
$ListingTable .= “$a1[rooms] bed-roomed $a1[PropertyType] in $a1[city], $a1[country]. Sleeps $a1[sleeps].n”;
}

  $ListingTable .= "<tr>nt<td width=75>";

  if(!empty($a1[image]))
  {
     $images = explode("|", $a1[image]);
     $MyImage = $images[0];

     $ListingTable .= "<img src="re_images/$MyImage" width=75 height=60 border=1>";
  }
  else
  {
     $ListingTable .= "<img src="no_image.gif" border=1>";
  }

  $ListingTable .= "</td>nt";

  $ListingTable .= "<td width=225 valign=top><b>Property ID: $a1[ListingID]</b><br>$a1[address], $a1[city]<br>$a1[state], $a1[country]</td>nt";
  $ListingTable .= "<td width=100 valign=top>$a1[rooms] Bedroom(s),<br> $a1[bathrooms] bathroom(s)";

  $min1 = $a1[MinPriceW];
  $min2 = $a1[MinPriceSp];
  $min3 = $a1[MinPriceA];
  $min4 = $a1[MinPriceSu];
  $divide = 4;
  $max1 = $a1[MaxPriceW];
  $max2 = $a1[MaxPriceSp];
  $max3 = $a1[MaxPriceA];
  $max4 = $a1[MaxPriceSu];
  $r_minprice = ($min1 + $min2 + $min3 + $min4) / $divide;
  $r_maxprice = ($max1 + $max2 + $max3 + $max4) / $divide;
  $MyPrice = number_format($r_minprice, 2, ".", ",");
  $MyPrice2 = number_format($r_maxprice, 2, ".", ",");

  $ListingTable .= "<br><strong>Price Range:</strong> $aset[Currencya]$MyPrice - $aset[Currencya]$MyPrice2 pw<br />n";

  $ListingTable .= "</tr>n";

  $ListingTable .= "<tr>nt<td colspan=4>$a1[ShortDesc]</td>n</tr>n";

  $ListingTable .= "</table>nn</td>n</tr>nn";

}

$ListingTable .= “

”; 
  $rnav = mysql_query($qnav) or die(mysql_error());
  $rows = mysql_num_rows($rnav);

     if($rows > $ByPage)
     {
        $ListingTable .=  "<br><table align=center width=100%>";
        $ListingTable .= "<td align=center><font face=verdana size=2> ";

        $pages = ceil($rows/$ByPage);

        for($i = 0; $i <= ($pages); $i++)
        {
           $PageStart = $ByPage*$i;

           $i2 = $i + 1;

           if($PageStart == $Start)
           {
              $links[] = " <span class=RedLink>$i2</span>nt ";
           }
           elseif($PageStart < $rows)
           {
              $links[] = " <a class=BlackLink href="search.php?Start=$PageStart&c=$_GET[c]&s=$_GET[s]&AgentID=$_GET[AgentID]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_PropertyType=$_GET[search_PropertyType]&MinPrice=$_GET[MinPrice]&MaxPrice=$_GET[MaxPrice]&rooms1=$_GET[rooms1]&rooms2=$_GET[rooms2]&bath1=$_GET[bath1]&bath2=$_GET[bath2]&before=$_GET[before]&school=$_GET[school]&transit=$_GET[transit]&park=$_GET[park]&ocean_view=$_GET[ocean_view]&lake_view=$_GET[lake_view]&mountain_view=$_GET[mountain_view]&ocean_waterfront=$_GET[ocean_waterfront]&lake_waterfront=$_GET[lake_waterfront]&river_waterfront=$_GET[river_waterfront]&city=$_GET[city]&p=$_GET[p]&r=$_GET[r]">$i2</a>nt ";
           }
        }

        //$links2 = implode(" | ", $links);

        //$ListingTable .= $links2;

        $ListingTable .= " </td>";

        $ListingTable .= "</table><br>n";

}
}
}
else
{
$ListingTable = “

No results were found!”;
}
[/code]

Thanks
Steve

#2

Why do you say it’s only executing half of the script? Have you used echo statements (or other debugging techniques, see the link in my signature) to conclude this? Is your $a2[‘PriorityLevel’] filled with the value you’re expecting? Are you getting any errors (with error_reporting(E_ALL); enabled)?

Sponsor our Newsletter | Privacy Policy | Terms of Service