Need some personalized help developing query

[javashackgirl]

I'm trying to complete this project I have going (that my db guy dropped in my lap), but I simply do not have the time to learn all that is required to build this query.

This project is way overdue, so I'm all looking for is someone who might do more than "help" me with it-- I need someone who is willing to construct the query for me. I have the search page built, the db is in place, all I need is the query.

Any takers?

TIA
Jessica

[maxpup979]

post the details--what is the table structure, what fields are you searching on--what DB are you using?

[javashackgirl]

Alright, well, the db is mysql.

The code for the search page is as follows:

<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<br>
					<input type="checkbox" name="prop_type[]" value="Farm & Ranch" border="0"> Farm and Ranch<br>
					<input type="checkbox" name="prop_type[]" value="Commerical Property" border="0"> Commerical Property<br>
				</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<br>
					<input type="checkbox" name="area[]" value="Mesa" border="0"> Mesa<br>
					<input type="checkbox" name="area[]" value="Midvale" border="0"> Midvale<br>
					<input type="checkbox" name="area[]" value="New Meadows" border="0"> New Meadows<br>
					and surrounding area</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>
						<option value="160,000">$160,000</option>
						<option value="180,000">$180,000</option>
						<option value="200,000">$200,000</option>
						<option value="250,000">$250,000</option>
						<option value="300,000">$300,000</option>
						<option value="350,000">$350,000</option>
						<option value="400,000">$400,000</option>
						<option value="500,000">$500,000</option>
						<option value="600,000">$600,000</option>
						<option value="700,00">$700,000</option>
						<option value="800,000">$800,000</option>
						<option value="900,000">$900,000</option>
						<option value="1000,000">$1000,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>
						<option value="110,000">$110,000</option>
						<option value="120,000">$120,000</option>
						<option value="130,000">$130,000</option>
						<option value="140,000">$140,000</option>
						<option value="160,000">$160,000</option>
						<option value="180,000">$180,000</option>
						<option selected value="200,000">$200,000</option>
						<option value="250,000">$250,000</option>
						<option value="300,000">$300,000</option>
						<option value="350,000">$350,000</option>
						<option value="400,000">$400,000</option>
						<option value="500,000">$500,000</option>
						<option value="600,000">$600,000</option>
						<option value="700,000">$700,000</option>
						<option value="800,000">$800,000</option>
						<option value="900,000">$900,000</option>
						<option value="1000,000">$1000,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>

The link to the page, so you can see what it looks like, is www.idahocountryproperties.net/listings2.html

Essentially, it's pretty self-expanatory. They make the selections, hit search. I need it to produce those results in order of descending price.

I know enough of php that I can somewhat format what I want it to look like on the search.php page (and I have the /listings.php page that my db got finished).

Is that enough?
Thanks