Search Problems

2 posts by 2 authors in: Forums > CMS Builder
Last Post: June 5, 2008 (RSS)

Archived
Reply
Reply

By Kenny - June 5, 2008

When performing a search between say $50,000 and $100,000 - it is returning all results.

Anything special when it comes to money searches I should know about? Every other search field works good.

<form method=POST action="http://www.dedeking.com/listings/index.php">
<p>

<p>


<p><br>
<b><font face="Helvetica" color="#800000">Search property listings</font></b></p>


<table border=0 cellspacing=1 cellpadding=5 id="table4">
  <tr>
   <td bgcolor="#FFFFFF">

    <table border=0 cellspacing=3 cellpadding=3 id="table5">
    <tr>
     <td><font face="arial" size=2>&nbsp;Price </font></td>
     <td>
      <select name="price_min">
      <option value="">Minimum
      <option value="">Any
      <option value="">$0
      <option>$50,000
      <option>$75,000
      <option>$100,000
      <option>$125,000
      <option>$150,000
      <option>$175,000
      <option>$200,000
      <option>$250,000
      <option>$500,000
      </select>
      &nbsp;
      <select name="price_max">
      <option value="">Maximum
      <option value="">Unlimited
      <option>$50,000
      <option>$75,000
      <option>$100,000
      <option>$125,000
      <option>$150,000
      <option>$175,000
      <option>$200,000
      <option>$250,000
      <option>$500,000
      <option>$1,000,000
      <option>$2,000,000
      </select>
     </td>
    </tr>
    <tr>
     <td><font face="arial" size=2>&nbsp;Bedrooms&nbsp;</font></td>
     <td>
      <select name="bedrooms_min">
      <option value="">Minimum
      <option value="">Any
      <option>1
      <option>2
      <option>3
      <option>4
      <option>5
      <option>6
      </select>
      &nbsp;
      <select name="bedrooms_max">
      <option value="">Maximum
      <option value="">Unlimited
      <option>0
      <option>1
      <option>2
      <option>3
      <option>4
      <option>5
      </select>
     </td>
    </tr>
    <tr>
     <td><font face="arial" size=2>&nbsp;Bathrooms&nbsp;&nbsp;</font></td>
     <td>
      <select name="bathrooms_min">
      <option value="">Minimum
      <option value="">Any
      <option>0
      <option>1
      <option>2
      <option>3
      <option>4
      <option>5
      </select>
      &nbsp;
      <select name="bathrooms_max">
      <option value="">Maximum
      <option value="">Unlimited
      <option>0
      <option>1
      <option>2
      <option>3
      <option>4
      <option>5
      </select>
     </td>
    </tr>
      <tr>
      <td><font size=2 face="arial">&nbsp;Type </font></td>
      <td>
       <select name="type_keyword">
       <option value="">Any
<option>Home
<option>Condos
<option>Townhouse
<option>Apartments
<option>Mobile Homes
<option>Lot
<option>Acreage
<option>Duplex
<option>Triplex
<option>Farm or Ranch
<option>Commercial Properties
<option>Other
       </select>
      </td>
     </tr>
     </table>

<p>
<div align=center>
<input type=submit name="search" value="  Search Listings  ">
</div>

</td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</form>

Re: [sagentic] Search Problems

Archived
Reply
Reply

By Dave - June 5, 2008

The values need to be all numeric, like this:

<option value="100000">$100,000</option>

Also it's a good idea to use closing option tags because some browsers will send the nextline return character and that won't match anything:

<option>Mobile Homes</option>

Hope that helps! Let me know if you need anything else.

Dave Edis - Senior Developer
interactivetools.com