Jump to content
Fórum Script Brasil
  • 0

Quero Colocar Uma Busca Aqui


mistermind
 Share

Question

3 answers to this question

Recommended Posts

  • 0

Coloca um textfield ali entre as tags FORM que já existem ali... o teu formulário usa o método GET, na página que é action pega esse novo dado que vai ser passado e usa na pesquisa...

Link to comment
Share on other sites

  • 0

ESSA E DA PARTE QUE EU QUERO que FUNCIONE

para cadastrar o produto é usado ShortDesc no formulario de cadastro, para mostrar o produto usa esse $a1[shortDesc] ,

como faço para que esse textfield busque no banco de dados?

<? require_once("busca_principal.php");?>      
      <form method=POST action="busca_avancada.php">
        
          <div align="left">
          </div>
          <table width=100% align=center bgcolor="#F4F4F4">
              <tr>
                <td width="99">                <p>
                  não FUCIONA 
                      <label>teste
                      <input type="text" name="palavras" id="palavras" />
                      </label>
                  ESSA BUSCA 
              </p>
                  <p> COMO que FA&Ccedil;O PRA FUNCIONAR 
                  
                  </p>
                  <p><br>
                  </p>                  </td>
            </tr>
              <tr>
                <td><p><strong>Em:</strong></p>
                  <p>
                    <?=$AgentsMenu?>
                    <br>
                  </p>
                  <p>
                    <?=$CityMenu?>
                    </p>
                  <p>&nbsp;                  </p>
                  <p>
                    <?=$StateMenu?>
                  </p>
                <p>&nbsp;</p></td>
            </tr>
              <tr>
                <td height="25">
                  <input type=submit name=s1 value="Buscar"></td>
              </tr>
          </table>
</form>
                      </div></td>
                    </tr>
                    <tr> 
                      <td><p>
                        <?=$Account?>
                        <?=$Categories?>

                      </p></td>
                    </tr>
                  </table></td>
                <td width="564" valign="top"><div align="center"> 
                    <table width="491" height="100%" border="0" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td width="479"><div align="center"></div></td>
                      </tr>

                      <tr> 
                        <td height="100%"><div align="center"> 
                            <p>
ESSA E DA BUSCA busca_principal.php
<?
require_once("configuracao_mysql.php");

if(isset($_POST[s1]))
{
    if(!empty($_POST[cat]))
    {
        $CatInfo = explode("|", $_POST[cat]);

        $c = $CatInfo[0];
        
        if($CatInfo[1] > '0')
        {
            $s = $CatInfo[1];
        }
    }

    if(!empty($_POST[search_country]))
    {
        $search_country = $_POST[search_country];
    }

    if(!empty($_POST[search_state]))
    {
        $state = $_POST[search_state];
    }

    if(!empty($_POST[search_city]))
    {
        $search_city = $_POST[search_city];
    }

    if(!empty($_POST[search_PropertyType]))
    {
        $search_PropertyType = $_POST[search_PropertyType];
    }

    if(!empty($_POST[MinPrice]))
    {
        $MinPrice = $_POST[MinPrice];
    }

    if(!empty($_POST[MaxPrice]))
    {
        $MaxPrice = $_POST[MaxPrice];
    }

    if(!empty($_POST[MinRooms]))
    {
        $rooms1 = $_POST[MinRooms];
    }

    if(!empty($_POST[MaxRooms]))
    {
        $rooms2 = $_POST[MaxRooms];
    }

    if(!empty($_POST[MinBath]))
    {
        $bath1 = $_POST[MinBath];
    }

    if(!empty($_POST[MaxBath]))
    {
        $bath2 = $_POST[MaxBath];
    }

    if(!empty($_POST[AgentID]))
    {
        $agent = $_POST[AgentID];
    }

    if(!empty($_POST[old]))
    {
        $before = $_POST[old];
    }

    if(!empty($_POST[NearSchool]))
    {
        $school = $_POST[NearSchool];
    }

    if(!empty($_POST[NearTransit]))
    {
        $transit = $_POST[NearTransit];
    }

    if(!empty($_POST[NearPark]))
    {
        $park = $_POST[NearPark];
    }

    if(!empty($_POST[OceanView]))
    {
        $ocean_view = $_POST[OceanView];
    }

    if(!empty($_POST[LakeView]))
    {
        $lake_view = $_POST[LakeView];
    }

    if(!empty($_POST[MountainView]))
    {
        $mountain_view = $_POST[MountainView];
    }

    if(!empty($_POST[OceanWaterfront]))
    {
        $ocean_waterfront = $_POST[OceanWaterfront];
    }

    if(!empty($_POST[LakeWaterfront]))
    {
        $lake_waterfront = $_POST[LakeWaterfront];
    }

    if(!empty($_POST[RiverWaterfront]))
    {
        $river_waterfront = $_POST[RiverWaterfront];
    }

    $url = "buscador.php?c=$c&s=$s&search_country=$_POST[search_country]&search_state=$_POST[search_state]&search_city=$_POST[search_city]&search_PropertyType=$_POST[search_PropertyType]&MaxPrice=$MaxPrice&MinPrice=$MinPrice&rooms1=$rooms1&rooms2=$rooms2&bath1=$bath1&bath2=$bath2&AgentID=$agent&before=$before&school=$school&transit=$transit&park=$park&ocean_view=$ocean_view&lake_view=
$lake_view&mountain_view=$mountain_view&ocean_waterfront=$ocean_waterfront&lake_waterfront=$lake_waterfront&river_waterfront=$river_waterfront";

    header("location:$url");
    exit();
}

require_once("includes.php");
/*
//create the category menu
$CategoryMenu = "<select name=cat>\n\t<option value=\"\"></option>\n\t";

$q1 = "select * from re2_categories order by CategoryName";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $CategoryMenu .= "<option value=\"$a1[CategoryID]|0\">$a1[CategoryName]</option>\n\t";

        //get the subcategories
        $q2 = "select * from re2_subcategories where CategoryID = '$a1[CategoryID]' order by SubcategoryName ";
        $r2 = mysql_query($q2) or die(mysql_error());
    
        while($a2 = mysql_fetch_array($r2))
        {
            $CategoryMenu .= "<option value=\"$a1[CategoryID]|$a2[SubcategoryID]\">$a1[CategoryName] - $a2[SubcategoryName]</option>\n\t";
        }

    }
}

$CategoryMenu .= "</select>\n";

*/
//create the state menu
$StateMenu = "<select name=search_state>\n\t<option value=\"\">Todos os Estados</option>\n\t";

$q1 = "select distinct state from re2_listings order by state";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $StateMenu .= "<option value=\"$a1[state]\">$a1[state]</option>\n\t";
    }
}

$StateMenu .= "</select>\n";

//create the city menu
$CityMenu = "<select name=search_city>\n\t<option value=\"\">Todas as Cidades</option>\n\t";

$q1 = "select distinct city from re2_listings order by city";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $CityMenu .= "<option value=\"$a1[city]\">$a1[city]</option>\n\t";
    }
}

$CityMenu .= "</select>\n";


//create the country menu
$CountryMenu = "<select name=search_country>\n\t<option value=\"\">Todos os países</option>\n\t";

$q1 = "select distinct country from re2_listings order by country";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $CountryMenu .= "<option value=\"$a1[country]\">$a1[country]</option>\n\t";
    }
}

$CountryMenu .= "</select>\n";

//create the PropertyType menu
$TypeMenu = "<select name=search_PropertyType>\n\t<option value=\"\">Todos os tipos</option>\n\t";

$q1 = "select distinct PropertyType from re2_listings order by PropertyType";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $TypeMenu .= "<option value=\"$a1[PropertyType]\">$a1[PropertyType]</option>\n\t";
    }
}

$TypeMenu .= "</select>\n";


//create the Price Minimum menu
$MinPrice = "<select name=MinPrice>\n\t<option value=\"\">Mínimo</option>\n\t";

$q1 = "select distinct Price from re2_listings order by Price asc";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $prices .= "<option value=\"$a1[Price]\">R$ $a1[Price]</option>\n\t";
    }
}

$MinPrice .= $prices."</select>\n";


//create the max price menu
$MaxPrice = "<select name=MaxPrice>\n\t<option value=\"\">Máximo</option>\n\t";
$MaxPrice .= $prices."</select>\n";

//bedrooms
$MinBed = "<select name=MinRooms>\n\t<option value=\"\">Mínimo</option>\n\t";

for($i = '0'; $i <= '20'; $i++)
{
    $bed .= "<option value=\"$i\">$i</option>\n\t";
}

$MinBed .= $bed."</select>\n";

$MaxBed = "<select name=MaxRooms>\n\t<option value=\"\">Máximo</option>\n\t";
$MaxBed .= $bed."</select>\n";

//bathrooms
$MinBath = "<select name=MinBath>\n\t<option value=\"\">Mínimo</option>\n\t";

for($i = '0'; $i <= '10'; $i++)
{
    $bath .= "<option value=\"$i\">$i</option>\n\t";
}

$MinBath .= $bath."</select>\n";

$MaxBath = "<select name=MaxBath>\n\t<option value=\"\">Máximo</option>\n\t";
$MaxBath .= $bath."</select>\n";

//agents menu
$q1 = "select AgentID, FirstName, LastName from re2_agents order by FirstName, LastName";
$r1 = mysql_query($q1) or die(mysql_error());

$AgentsMenu = "<select name=AgentID>\n\t<option value=\"\">Todos os agentes</option>\n\t";

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $AgentsMenu .= "<option value=\"$a1[AgentID]\">$a1[FirstName] $a1[LastName]</option>\n\t";
    }
}

$AgentsMenu .= "</select>\n";


?>
ESSA E DA BUSCA busca_avancada.php
<?
require_once("configuracao_mysql.php");

if(isset($_POST[s1]))
{
    if(!empty($_POST[cat]))
    {
        $CatInfo = explode("|", $_POST[cat]);

        $c = $CatInfo[0];
        
        if($CatInfo[1] > '0')
        {
            $s = $CatInfo[1];
        }
    }

    if(!empty($_POST[search_country]))
    {
        $search_country = $_POST[search_country];
    }

    if(!empty($_POST[search_state]))
    {
        $state = $_POST[search_state];
    }

    if(!empty($_POST[search_city]))
    {
        $search_city = $_POST[search_city];
    }

    if(!empty($_POST[search_PropertyType]))
    {
        $search_PropertyType = $_POST[search_PropertyType];
    }

    if(!empty($_POST[MinPrice]))
    {
        $MinPrice = $_POST[MinPrice];
    }

    if(!empty($_POST[MaxPrice]))
    {
        $MaxPrice = $_POST[MaxPrice];
    }

    if(!empty($_POST[MinRooms]))
    {
        $rooms1 = $_POST[MinRooms];
    }

    if(!empty($_POST[MaxRooms]))
    {
        $rooms2 = $_POST[MaxRooms];
    }

    if(!empty($_POST[MinBath]))
    {
        $bath1 = $_POST[MinBath];
    }

    if(!empty($_POST[MaxBath]))
    {
        $bath2 = $_POST[MaxBath];
    }

    if(!empty($_POST[AgentID]))
    {
        $agent = $_POST[AgentID];
    }

    if(!empty($_POST[old]))
    {
        $before = $_POST[old];
    }

    if(!empty($_POST[NearSchool]))
    {
        $school = $_POST[NearSchool];
    }

    if(!empty($_POST[NearTransit]))
    {
        $transit = $_POST[NearTransit];
    }

    if(!empty($_POST[NearPark]))
    {
        $park = $_POST[NearPark];
    }

    if(!empty($_POST[OceanView]))
    {
        $ocean_view = $_POST[OceanView];
    }

    if(!empty($_POST[LakeView]))
    {
        $lake_view = $_POST[LakeView];
    }

    if(!empty($_POST[MountainView]))
    {
        $mountain_view = $_POST[MountainView];
    }

    if(!empty($_POST[OceanWaterfront]))
    {
        $ocean_waterfront = $_POST[OceanWaterfront];
    }

    if(!empty($_POST[LakeWaterfront]))
    {
        $lake_waterfront = $_POST[LakeWaterfront];
    }

    if(!empty($_POST[RiverWaterfront]))
    {
        $river_waterfront = $_POST[RiverWaterfront];
    }

    $url = "buscador.php?c=$c&s=$s&search_country=$_POST[search_country]&search_state=$_POST[search_state]&search_city=$_POST[search_city]&search_PropertyType=$_POST[search_PropertyType]&MaxPrice=$MaxPrice&MinPrice=$MinPrice&rooms1=$rooms1&rooms2=$rooms2&bath1=$bath1&bath2=$bath2&AgentID=$agent&before=$before&school=$school&transit=$transit&park=$park&ocean_view=$ocean_view&lake_view=$lake_view&mountain_view=
$mountain_view&ocean_waterfront=$ocean_waterfront&lake_waterfront=$lake_waterfront&river_waterfront=$river_waterfront";

    header("location:$url");
    exit();
}

require_once("includes.php");
/*
//create the category menu
$CategoryMenu = "<select name=cat>\n\t<option value=\"\"></option>\n\t";

$q1 = "select * from re2_categories order by CategoryName";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $CategoryMenu .= "<option value=\"$a1[CategoryID]|0\">$a1[CategoryName]</option>\n\t";

        //get the subcategories
        $q2 = "select * from re2_subcategories where CategoryID = '$a1[CategoryID]' order by SubcategoryName ";
        $r2 = mysql_query($q2) or die(mysql_error());
    
        while($a2 = mysql_fetch_array($r2))
        {
            $CategoryMenu .= "<option value=\"$a1[CategoryID]|$a2[SubcategoryID]\">$a1[CategoryName] - $a2[SubcategoryName]</option>\n\t";
        }

    }
}

$CategoryMenu .= "</select>\n";

*/
//create the state menu
$StateMenu = "<select name=search_state>\n\t<option value=\"\">Todos os Estados</option>\n\t";

$q1 = "select distinct state from re2_listings order by state";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $StateMenu .= "<option value=\"$a1[state]\">$a1[state]</option>\n\t";
    }
}

$StateMenu .= "</select>\n";

//create the city menu
$CityMenu = "<select name=search_city>\n\t<option value=\"\">Todas as Cidades</option>\n\t";

$q1 = "select distinct city from re2_listings order by city";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $CityMenu .= "<option value=\"$a1[city]\">$a1[city]</option>\n\t";
    }
}

$CityMenu .= "</select>\n";


//create the country menu
$CountryMenu = "<select name=search_country>\n\t<option value=\"\">Todos os países</option>\n\t";

$q1 = "select distinct country from re2_listings order by country";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $CountryMenu .= "<option value=\"$a1[country]\">$a1[country]</option>\n\t";
    }
}

$CountryMenu .= "</select>\n";

//create the PropertyType menu
$TypeMenu = "<select name=search_PropertyType>\n\t<option value=\"\">Todos os tipos</option>\n\t";

$q1 = "select distinct PropertyType from re2_listings order by PropertyType";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $TypeMenu .= "<option value=\"$a1[PropertyType]\">$a1[PropertyType]</option>\n\t";
    }
}

$TypeMenu .= "</select>\n";


//create the Price Minimum menu
$MinPrice = "<select name=MinPrice>\n\t<option value=\"\">Mínimo</option>\n\t";

$q1 = "select distinct Price from re2_listings order by Price asc";
$r1 = mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $prices .= "<option value=\"$a1[Price]\">R$ $a1[Price]</option>\n\t";
    }
}

$MinPrice .= $prices."</select>\n";


//create the max price menu
$MaxPrice = "<select name=MaxPrice>\n\t<option value=\"\">Máximo</option>\n\t";
$MaxPrice .= $prices."</select>\n";

//bedrooms
$MinBed = "<select name=MinRooms>\n\t<option value=\"\">Mínimo</option>\n\t";

for($i = '0'; $i <= '20'; $i++)
{
    $bed .= "<option value=\"$i\">$i</option>\n\t";
}

$MinBed .= $bed."</select>\n";

$MaxBed = "<select name=MaxRooms>\n\t<option value=\"\">Máximo</option>\n\t";
$MaxBed .= $bed."</select>\n";

//bathrooms
$MinBath = "<select name=MinBath>\n\t<option value=\"\">Mínimo</option>\n\t";

for($i = '0'; $i <= '10'; $i++)
{
    $bath .= "<option value=\"$i\">$i</option>\n\t";
}

$MinBath .= $bath."</select>\n";

$MaxBath = "<select name=MaxBath>\n\t<option value=\"\">Máximo</option>\n\t";
$MaxBath .= $bath."</select>\n";

//agents menu
$q1 = "select AgentID, FirstName, LastName from re2_agents order by FirstName, LastName";
$r1 = mysql_query($q1) or die(mysql_error());

$AgentsMenu = "<select name=AgentID>\n\t<option value=\"\">Todos os agentes</option>\n\t";

if(mysql_num_rows($r1) > '0')
{
    while($a1 = mysql_fetch_array($r1))
    {
        $AgentsMenu .= "<option value=\"$a1[AgentID]\">$a1[FirstName] $a1[LastName]</option>\n\t";
    }
}

$AgentsMenu .= "</select>\n";

require_once("templates/HeaderTemplate.php");
require_once("templates/AdvancedSearchTemplate.php");

if(!ereg("index.php", $_SERVER[SCRIPT_NAME]))
{
    require_once("templates/FooterTemplate.php");    
}

?>
ESSE DO buscador.php
<?
require_once("configuracao_mysql.php");
require_once("includes.php");

$query = array();

if(!empty($_GET[c]))
{
    $query[] = "re2_listings.CategoryID = '$_GET[c]' ";
}

if(!empty($_GET[s]))
{
    $query[] = "re2_listings.SubcategoryID = '$_GET[s]' ";
}

if(!empty($_GET[AgentID]))
{
    $query[] = "re2_listings.AgentID = '$_GET[AgentID]' ";
}

if(!empty($_GET[search_country]))
{
    $query[] = "re2_listings.country = '$_GET[search_country]' ";
}

if(!empty($_GET[search_state]))
{
    $query[] = "re2_listings.state = '$_GET[search_state]' ";
}

if(!empty($_GET[search_city]))
{
    $query[] = "re2_listings.city = '$_GET[search_city]' ";
}

if(!empty($_GET[search_PropertyType]))
{
    $query[] = "re2_listings.PropertyType = '$_GET[search_PropertyType]' ";
}

if(!empty($_GET[MinPrice]))
{
    $query[] = "re2_listings.price >= '$_GET[MinPrice]' ";
}

if(!empty($_GET[MaxPrice]))
{
    $query[] = "re2_listings.price <= '$_GET[MaxPrice]' ";
}

if(!empty($_GET[rooms1]))
{
    $query[] = "re2_listings.rooms >= '$_GET[rooms1]' ";
}

if(!empty($_GET[rooms2]))
{
    $query[] = "re2_listings.rooms <= '$_GET[rooms2]' ";
}

if(!empty($_GET[bath1]))
{
    $query[] = "re2_listings.bathrooms >= '$_GET[bath1]' ";
}

if(!empty($_GET[bath2]))
{
    $query[] = "re2_listings.bathrooms <= '$_GET[bath2]' ";
}

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

if(!empty($_GET[school]))
{
    $query[] = "re2_listings.NearSchool = 'y' ";
}

if(!empty($_GET[transit]))
{
    $query[] = "re2_listings.NearTransit = 'y' ";
}

if(!empty($_GET[park]))
{
    $query[] = "re2_listings.NearPark = 'y' ";
}

if(!empty($_GET[ocean_view]))
{
    $query[] = "re2_listings.OceanView = 'y' ";
}

if(!empty($_GET[lake_view]))
{
    $query[] = "re2_listings.LakeView = 'y' ";
}

if(!empty($_GET[mountain_view]))
{
    $query[] = "re2_listings.MountainView = 'y' ";
}

if(!empty($_GET[ocean_waterfront]))
{
    $query[] = "re2_listings.OceanWaterfront = 'y' ";
}

if(!empty($_GET[lake_waterfront]))
{
    $query[] = "re2_listings.LakeWaterfront = 'y' ";
}

if(!empty($_GET[river_waterfront]))
{
    $query[] = "re2_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[] = " re2_listings.DateAdded desc ";
        }
        
        if($ov == "Price")
        {
            $order[] = " re2_listings.Price asc ";
        }
        
        if($ov == "address")
        {
            $order[] = " re2_listings.address asc ";
        }

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

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

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

}


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

}

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


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

$ByPage = '10';

$q1 = "select * from re2_listings, re2_agents, re2_priority where re2_listings.AgentID = re2_agents.AgentID and re2_agents.PriorityLevel = re2_priority.PriorityLevel and re2_agents.AccountStatus = 'active' $MyQuery $MyOrder limit $Start, $ByPage ";

$qnav = "select * from re2_listings, re2_agents where re2_listings.AgentID = re2_agents.AgentID $MyQuery";

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

if($lrows > '0')
{
    $ListingTable .= "<table align=center width=530 cellspacing=0>\n";
    $ListingTable .= "<tr>\n<td width=75>&nbsp;</td>\n\t";
        
    $ListingTable .= "</tr>\n</table>\n\n";

    $ListingTable .= "<table align=center width=530 border=0 bordercolor=#336699 rules=rows cellspacing=0>\n";

    while($a1 = mysql_fetch_array($r1))
    {
        $ListingTable .= "<tr style=\"border-width:0; border-color:blue\" onMouseOver=\"this.style.background='#F4F4F4'; this.style.cursor='hand'\" onMouseOut=\"this.style.background='white'\" onClick=\"window.open('anuncio.php?id=$a1[ListingID]', '_top')\">\n\t";
        $ListingTable .= "<td height=60>";

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

        $ListingTable .= "<tr>\n\t<td width=75>";

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

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

        $ListingTable .= "</td>\n\t";

        $ListingTable .= "<td width=225 valign=top><b> $a1[ShortDesc]</b><br>$a1[city], $a1[state]<br>$a1[address], $a1[country]</td>\n\t";
        

        if($a1[garage] > '0')
        {
            
        }

        $MyPrice = number_format($a1[Price], 2, ".", ",");

        $ListingTable .= "</td>\n\t<td align=center width=100 valign=top><b>R$$MyPrice</td>\n";

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

        $ListingTable .= "<tr>\n\t<td colspan=4>$a1[ListingID]</td>\n</tr>\n";

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

    }

    $ListingTable .= "</table>";

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

            if($rows > $ByPage)
            {
                $ListingTable .=  "<br><table align=center width=580>";
                $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>\n\t ";
                    }
                    elseif($PageStart < $rows)
                    {
                        $links[] = " <a class=BlackLink href=\"buscador.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>\n\t ";    
                    }
                }

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

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

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

            }
}
else
{
    $ListingTable = "<br><br><center>Nenhum resultado encontrado!</center>";
}

require_once("templates/HeaderTemplate.php");
require_once("templates/SearchTemplate.php");    
require_once("templates/FooterTemplate.php");

?>

Edited by mistermind
Link to comment
Share on other sites

  • 0

mistermind, acho que você não percebeu ainda, bom, não é permitido ficar abrindo vários tópicos com a mesma dúvida, semana passada você fez isso e agora está repetindo de novo... da próxima eu aviso um monitor do fato.

Quanto a sua dúvida, junte tudo que eu já disse e tente.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Forum Statistics

    • Total Topics
      149.8k
    • Total Posts
      646.6k
×
×
  • Create New...