Interactivetools.com Forum: Products: CMS Builder: Search Problems

Home: Products: CMS Builder:
Search Problems

sagentic
User

Jun 5, 2008, 12:24 PM

Post #1 of 2 (117 views)
Shortcut

Search Problems	Can't Post

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.

Code

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

Dave
Staff / Moderator

Jun 5, 2008, 1:00 PM

Post #2 of 2 (114 views)
Shortcut

Re: [sagentic] Search Problems [In reply to]	Can't Post

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

Search for (options)