Search mysql db

javashackgirl

Here's what I'm trying to create:
http://www.idahocountryproperties.net/listings2.php

The trouble I'm having (besides the fact that I can't find any search examples that are anywhere similar to this so I can figure it out) is first, how do I pass all of those variables to search.php? Typically, all of the examples that I've seen, they pass the specific field: ['id'] or whatever. They pull that specific field from the db. Trouble is, the way I've got this set up here (which, I believe, is the way my client would want it), they have several options to choose from, so instead of simply passing ['location'], I'm now passing ALL of those locations!

Thing is with that, is then, if I pass all of those locations, then from search.php, I'm going to have to say $_GET['Cambridge','Council'..... etc], right?

The price would be easier because of the style, all I would have is $_GET['minprice','maxprice'] and then run them through the search accordingly.

Am I right on this?

Here's the code of listings2:

<body><?php include 'top.php'; ?>
	<form action="search.php" method="post" name="search">
	<table border="0" cellspacing="5" cellpadding="4">
			<tr>
				<td colspan="2">
				<div align="center">
					<h2><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="In Town" value="In Town" border="0"> In Town<br>
					<input type="checkbox" name="On Acreage" value="On Acreage" border="0"> On Acreage<br>
					<input type="checkbox" name="Bare Land" value="Bare Land" border="0"> Bare Land<br>
					<input type="checkbox" name="Farm Land" value="Farm Land" border="0"> Farm Land<br>
					<input type="checkbox" name="Commerical Property" 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="Council" value="Council" border="0"> Council<br>
					<input type="checkbox" name="Cambridge" value="Cambridge" border="0"> Cambridge<br>
					<input type="checkbox" name="Fruitvale" value="Fruitvale" border="0"> Fruitvale<br>
					<input type="checkbox" name="Mesa" value="Mesa" border="0"> Mesa<br>
					<input type="checkbox" name="Midvale" value="Midvale" border="0"> Midvale<br>
				</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 value="60,000">$60,000</option>
						<option selected 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>

dcooper

u after something like

SELECT * FROM table where location='$selection'1 and location='$selection2'

hmm im not entirely sure thats the solution your after, since i dont know how sql would react if a variable was empty i.e they only selected one

might be worth a try tho

jakem

No, you don't have to use $_GET['Cambridge','Council'..... etc]....There is a much easier way to gather the data on your search.php page.
Instead of giving each of your location checkboxes names like "Cambridge" or "Fruitvale", give them all one generic variable name like "Locations" followed by a set of brackets "[]". This will allow you to grab all of the values as an array on search.php. Here's an example of what I mean:

On your search page, the location checkbox section looks something like this:

<input type="checkbox" name="Locations[]" value="Location 1">
<input type="checkbox" name="Locations[]" value="Location 2">
<input type="checkbox" name="Locations[]" value="Location 3">

Now in search.php you can just use $Locations=$_GET['Locations'] and you've got an array of all of the checkbox values.

$Locations[0] would contain "Location 1" if that box had been checked, otherwise it is empty.

$locations[1] would contain "Location 2" if that box had been checked

etc,etc,etc.

So in your sql statement you would just need to check if the values are blank, and if not add an " AND Location='$Locations[x]'".

I'm not sure if I've explained that well enough or not...but if you have any questions just ask