[Resolved] Forms + Database and recordset

cody44

I am setting up a small website that holds content for property. I have set up the database which consists of one table with the following fields;

id ( generates a cronilogical number for reference)
address ( user inputs the address here)
area ( This displays the district or area of the property)
bedrooms ( displays the number of bedrooms)
price (displays the price of the property)
image (displays the image of the property)

I have set up an admin page to delete, add or edit the database which works fine.

I have now set up a form called “form1” which will query the database and return the results into “results.php”
The form structure is as below.
I have a minimum dropdown box called “minimum” which gives a minimum price to select .
Also I have another drop down box called “maximum” which gives a maximum price to select.

I also have a dropdown menu displaying number of bedrooms called “bedrooms” for the viewer to select number of bedrooms ie, 2+,3+,4+,5+.

Then finally I have done a select area, displaying areas with a checkbox next to them for the user to select specific areas to search.

When the form is submitted it will go to “results.php” displaying the outcome.

Now what is getting to me is how to bring the “form1” query into the “results.php” page. Basically I need some help on this on how to set the recordset, query and behaviours.

I am very much a newbie but learning bit by bit.................(please go easy)

Any guidance would be greatly appreciated.

Mark

snoopy13

first you check which field are filled in:
if ($maximum=="") $maximum="%%";
etc.

then you make the query ... for every checkbox of the area you make another area LIKE '$area1' etc.

$query=mysql_query("SELECT * FROM table WHERE price>='$minimum' AND price<='$maximum' AND bedrooms>='$bedrooms' AND area LIKE '$area1' AND area LIKE '$area2'");
$array=mysql_fetch_array($query)

is it this what you wanted to know?

cody44

Many thanks Snoopy,
Been working on this for a good two weeks now, below is the code for the "Search" form.

<form name="form1" method="post" action="results.php">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="6"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Please
enter your search criteria below.</font></td>
</tr>
<tr>
<td width="20%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td colspan="5"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Minimum
Price range</font></td>
<td colspan="3"><select name="price" id="price">
<option value="20000">£20'000</option>
<option value="30000">£30'000</option>
<option value="40000">£40'000</option>
<option value="50000">£50'000</option>
<option value="55000">£55'000</option>
<option value="60000">£60'000</option>
<option value="65000">£65'000</option>
<option value="70000">£70'000</option>
<option value="75000">£75'000</option>
<option value="80000">£80'000</option>
<option value="85000">£85'000</option>
<option value="90000">£90'000</option>
<option value="95000">£95'000</option>
<option value="100000">£100'000</option>
<option value="105000">£105'000</option>
<option value="110000">£110'000</option>
<option value="115000">£115'000</option>
<option value="120000">£120'000</option>
<option value="125'000">£125'000</option>
<option value="130'000">£130'000</option>
<option value="135000">£135'000</option>
<option value="140000">£140'000</option>
<option value="140000">£145'000</option>
<option value="150000">£150'000</option>
<option value="155000">£155'000</option>
<option value="160000">£160'000</option>
<option value="165000">£165'000</option>
<option value="170000">£170'000</option>
<option value="175000">£175'000</option>
<option value="180000">£180'000</option>
<option value="185000">£185'000</option>
<option value="190000">£190'000</option>
<option value="195000">£195'000</option>
<option value="200000">£200'000</option>
<option value="250000">£250'000</option>
<option value="300000">£300'000</option>
<option value="350000">£350'000</option>
<option value="400000">£400'000</option>
<option value="450000">£450'000</option>
<option value="500000">£500'000</option>
<option value="550000">£550'000</option>
<option value="600000">£600'000</option>
</select> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td width="18%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Maximum
Price Range</font></td>
<td width="38%"><select name="price" id="price">
<option value="600000">£600'000</option>
<option value="550000">£550'000</option>
<option value="500000">£500'000</option>
<option value="450000">£450'000</option>
<option value="400000">£400'000</option>
<option value="350000">£350'000</option>
<option value="300000">£300'000</option>
<option value="250000">£250'000</option>
<option value="200000">£200'000</option>
<option value="180000">£180'000</option>
<option value="160000">£160'000</option>
<option value="140000">£140'000</option>
<option value="135000">£135'000</option>
<option value="130000">£130'000</option>
<option value="125000">£125'000</option>
<option value="120000">£120'000</option>
<option value="115000">£115'000</option>
<option value="110000">£110'000</option>
<option value="105000">£105'000</option>
<option value="100000">£100'000</option>
<option value="95000">£95'000</option>
<option value="90000">£90'000</option>
<option value="85000">£85'000</option>
<option value="80000">£80'000</option>
<option value="75000">£75'000</option>
<option value="70000">£70'000</option>
<option value="65000">£65'000</option>
<option value="60000">£60'000</option>
<option value="55000">£55'000</option>
<option value="50000">£50'000</option>
<option value="45000">£45'000</option>
<option value="40000">£40'000</option>
<option value="35000">£35'000</option>
<option value="30000">£30'000</option>
</select></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
<td colspan="5"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Bedrooms</font></td>
<td colspan="5"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="bedrooms" id="bedrooms">
<option value="any">Any</option>
<option value="1>">1+</option>
<option value="2>">2+</option>
<option value="3>">3+</option>
<option value="4>">4+</option>
<option value="5>">5+</option>
</select>
</font></td>
</tr>
<tr>
<td> </td>
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5"> </td>
<td> </td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">*
If No area's are selected below you will receive property information
for all area's.</font></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr>
<?php $horizcount=0; do {
$areaname = $row_area['area'];
if (!$areaname) { $areaname = "No Area"; }
$count = $row_area['count'];
echo "<td><input type=\"checkbox\" value=\"$areaname\"> $areaname ($count)</td>";
$horizcount +=1;
if ($horizcount == 4) { echo "</tr><tr>"; $horizcount=0; }
} while ($row_area = mysql_fetch_assoc($area)); ?>
</tr>

<tr>
  <td>&nbsp;</td>
</tr>
<tr> 
  <td><input type="submit" name="Submit" value="Submit"></td>
</tr>

</table>
</form>

The problem I have is setting out the query in the results page and stringing them together. Maybe im making it too complicated.

Any help appreciated

Mark