javashackgirl - 9:47 pm on Nov 13, 2003 (gmt 0)

Yes, something like that. Trouble is, I have ... well, I can't post the link to the page, so here's the code:

[php]
<form action="test.php" method="get" name="search">
<table border="0" cellspacing="5" cellpadding="4">
<tr>
<td colspan="2">
<div align="center">
<h2><br>
<br>
<font face="Courier New,Courier,Monaco"><b><font color="#cb4927">Property Search</font></b></font></h2>
</div>
</td>
</tr>
<tr>
<td valign="top" width="50%">
<div align="right">
<font color="#cb4927"><b>Property Type </b></font></div>
</td>
<td valign="top" width="50%">
<input type="checkbox" name="prop_type[]" value="Residential" border="0"> Residential<br>
<input type="checkbox" name="prop_type[]" value="Residential On Acreage" border="0"> Residential On Acreage<br>
<input type="checkbox" name="prop_type[]" value="Bare Land" border="0"> Bare Land
</td>
</tr>
<tr>
<td valign="top" width="50%">
<div align="right">
<font color="#cb4927"><b>Area </b></font></div>
</td>
<td width="50%">
<input type="checkbox" name="area[]" value="Council" border="0"> Council <br>
and surrounding area<br>
<input type="checkbox" name="area[]" value="Cambridge" border="0"> Cambridge<br>
<input type="checkbox" name="area[]" value="Fruitvale" border="0"> Fruitvale</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<font color="#cb4927"><b>Min. and Max. Price Range</b></font></div>
</td>
</tr>
<tr>
<td width="50%">
<div align="right">
<select name="minprice" size="1">
<option value="0">None</option>
<option value="20,000">$20,000</option>
<option value="40,000">$40,000</option>
<option selected value="60,000">$60,000</option>
<option value="80,000">$80,000</option>
<option value="100,000">$100,000</option>
<option value="120,000">$120,000</option>
<option value="140,000">$140,000</option>
</select></div>
</td>
<td width="50%"><select name="maxprice" size="1">
<option value="0">None</option>
<option value="20,000">$20,000</option>
<option value="40,000">$40,000</option>
<option value="60,000">$60,000</option>
<option value="80,000">$80,000</option>
<option value="100,000">$100,000</option>
</select></td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="submit" name="Submit" value="Perform Search" border="0"></div>
</td>
</tr>
</table>
</form>
</body>
[/php]

There are 3 main fields they have to choose from: prop_type[], area[], and price (min and max). The query must produce homes that fit ALL of those fields. That's where I'm getting stuck.

And then they have to post in order of descending price. (I have the first page my db guy wrote, and I can copy a lot of the format from that for layout.)

[edited by: jatar_k at 5:19 am (utc) on Nov. 14, 2003]
[edit reason] trimmed down the code for readability [/edit]