/    Sign up×
Community /Pin to ProfileBookmark

Property search?

Hi all,

Im still struggling with the multiple search options to display a result. I have had a look at PHP and my SQL from nothing and find it hard to find only the bits i need.

I now have this code (Below) this is for the drop down buttons where the user selects their value and a search button. Could somone please tell me what i have to create behind this and how to do it.

Thanks in advance Rob – Code follows –

<html>
<head>
<title>Commercial property services within Essex, London, Suffolk, Herts</title>

<META NAME=”Keywords” CONTENT=”free property search, new homes, houses for

sale, property for sale, financial services, Stansted Mountfitchet, Long Melford, Bishops

Stortford, Mayfair London, Saffron Walden, Essex, Hertfordshire, Cambridgeshire, Suffolk,”>
<META NAME=”Description” CONTENT=”Dedicated commercial property services Essex, London,

Suffolk, Herts”>
<link href=”/mwlight.css” rel=”stylesheet” type=”text/css” media=”screen”>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″>
<script type=”text/javascript” src=”webcertain.js”></script>
</head>

<body>

<p><form method=”post”

action=”http://www.fastcropit.com/mugr/html/templates/mullucks_search_pages/results.cfm“>
<input type=”hidden” value=”MUGR” name=”Group”/> <input type=”hidden”

value=”rentalSearch” name=”searchType”/> <input type=”hidden” value=”M” name=”space”/>
<table cellspacing=”4″ cellpadding=”1″ align=”center”>
<tbody>
<tr>
<td><strong>Properties to Let </strong></td>
</tr>
<tr>
<td valign=”top”>Select from the options belown and then press the search

button.<br/>
<br/>
<table>
<tbody>
<tr>
<td width=”96″>Minimum <br/>
Price </td>
<td width=”104″><select size=”1″ name=”Minprice”>
<option>&pound;100 </option>
<option>&pound;150 </option>
<option>&pound;200 </option>
<option selected=””>&pound;250 </option>
<option>&pound;300 </option>
<option>&pound;400 </option>
<option>&pound;500 </option>
<option>&pound;750 </option>
<option>&pound;1000 </option>
<option>&pound;2000 </option>
</select></td>
</tr>
<tr>
<td width=”96″>Maximum Price</td>
<td width=”104″><select size=”1″ name=”Maxprice”>
<option>&pound;150 </option>
<option>&pound;200 </option>
<option>&pound;250 </option>
<option>&pound;300 </option>
<option>&pound;400 </option>
<option selected=””>&pound;500 </option>
<option>&pound;750 </option>
<option>&pound;1000 </option>
<option>&pound;2000 </option>
<option>&pound;5000+ </option>
</select></td>
</tr>
<tr>
<td width=”96″>Minimum Bedrooms </td>
<td width=”104″><select name=”MinBedrooms”>
<option>1 </option>
<option selected=””>2 </option>
<option>3 </option>
<option>4 </option>
<option>5 </option>
<option>6 </option>
</select></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type=”submit” border=”0″ alt=”Search for Property”

name=”imageField2″ value=”Search”/></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</form></p>

</body>
</html>

to post a comment
JavaScript

3 Comments(s)

Copy linkTweet thisAlerts:
@WoDAug 30.2005 — What: You have to create a php-driven search function that will query a mysql database of properties with the parameters input into the form by an end user.

How: Hire somebody else to do it.
Copy linkTweet thisAlerts:
@sparqAug 30.2005 — What: You have to create a php-driven search function that will query a mysql database of properties with the parameters input into the form by an end user.

How: Hire somebody else to do it.[/QUOTE]

:p ?
Copy linkTweet thisAlerts:
@sparqAug 30.2005 — Oh, and I see ".cfm" -- so you are using ColdFusion.

I could do it for you ?
×

Success!

Help @DDR400_Rob spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.19,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...