@tunde
nice post but I have some reviews though

1- I personally don't like procedural codes so if someone working for me wrote those codes I will think its nasty and difficult to debug

2- I think magic_gpc_quotes() addslashes() are not best against sql injection. mysql_real_esapce_string(): is actually the best against sql injection

those are my main reviews to that code.

as for what the code is to do, I believe that part is trivial, using AND and OR depending on how you the developer wants the search to operate and thats what I have not understood from your post

2- I think magic_gpc_quotes() addslashes() are not best against sql injection. mysql_real_esapce_string(): is actually the best against sql injection

I will agree with mambenanje. Instead of just using magic_gc_quotes() and addslashes() you should also use mysql_real_escape_string() (to escape the posted data if magic qoutes is turned off for extra security). And as for using AND/OR it depends on what you are performing the search on.

There are free tutorials step-by-step create a webform using Dreamweaver MX recordsets, PHP, MySQL at below: (that is basically similar to your complex/advanced search form)

Build PHP applications with Dreamweaver MX
http://www.sitepoint.com/article/macromedia-dreamweaver-mx

Search Engine and Display Categories Page With Dreamweaver CS3, PHP5 and MySQL5
http://www.sebastiansulinski.co.uk/web_design_tutorials/dreamweaver/link_exchange_system_part_3_a.php

Dreamweaver MySQL/PHP tutorials
http://www.nebulex.com/index.php/tutorials/dreamweaver/mysqlphp/11

Paid subscription tutorials:

Dreamweaver MX and PHP Recordsets Explained - Web Designers and Developers Zone
http://www.dmxzone.com/ShowDetail.asp?NewsId=5278

Create a Simple Database Web Search - Part 1, Part 2 with PHP and Part 3 with ColdFusion
http://www.communitymx.com/abstract.cfm?cid=A7F6C

To me, you ask for someone who is Dreamweaver fluent you seek for help how to build complex/advanced search form using Dreamweaver recordsets with PHP and MySQL.

I gave you basic simple search form links mentioned previous posting in order for you to get idea switching from simple to advanced search form using Dreamweaver recordset configuration linking to both PHP/MySQL.

Or other way you can purchase the Dreamweaver extension (add-on plugins) for PHP/MySQL connection together setting up Dreamweaver recordset.

Am I right or wrong? @tundewoods

@tundewoods

I assume that you already create MySQL database table that named "homes" on your (or client's) database server.

The homes database table should be look like this:

id
keyword
type
option
minprice
maxprice

Also I assumed that you already create the following scripts: "search_form.php" like picture you posted previously and "search_result.php".

The following clickable link I give you basic tutorial how to set up dynamic database-driven search box using Dreamweaver recordset to add dynamic Text Fields on recordset connection. That link I provided you has its own working search form VIDEO TUTORIAL at bottom of its linked page.

I believe that you already created Dreamweaver recordset name: rsHomes_db to be connected with above home database table. So inside the search_form.php each textfield should named as I give out each textfield names. See picture below.

I think the poster is faced with the problem of creating a complex search form and/or query and he needs help. Or, am I wrong?