search multipul fields in a database

Report · May 09, 2006

hi there,

im working on a scouting website, and i have a database that has details of camps all over the northeast. all this data is housed on one table. each row houses the info for one camp, and each column represents an attribute. there are about 170 rows. i need to make a search form with several check boxes, one for each camp attribute, and when the database is searched, the boxes that are checked are checked against their courrosponding colums in the database for a string, usually "yes" . then on the results page, only camps that got positive matches on all of the checked attributes are displayed. if a box is not checked, it is ignored, so the value in the db can be anything. id like to do this with php, and im working with a MySQL db, and using DW8, and on a Linux server running apache. im not sure where to even start. im not too literate in php or sql, so any help you can offer is greatly appreciated. thanks a lot!

Report · May 09, 2006

Read up on getting a connection in DW to you database. Then you will be able
to build the forms and the queries to search the database.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"jmack159" <webforumsuser@macromedia.com> wrote in message
news:e3pgp0$5ca$1@forums.macromedia.com...
> hi there,
>
> im working on a scouting website, and i have a database that has details
> of
> camps all over the northeast. all this data is housed on one table. each
> row
> houses the info for one camp, and each column represents an attribute.
> there
> are about 170 rows. i need to make a search form with several check boxes,
> one
> for each camp attribute, and when the database is searched, the boxes that
> are
> checked are checked against their courrosponding colums in the database
> for a
> string, usually "yes" . then on the results page, only camps that got
> positive
> matches on all of the checked attributes are displayed. if a box is not
> checked, it is ignored, so the value in the db can be anything. id like to
> do
> this with php, and im working with a MySQL db, and using DW8, and on a
> Linux
> server running apache. im not sure where to even start. im not too
> literate in
> php or sql, so any help you can offer is greatly appreciated. thanks a
> lot!
>
>