Search by checkbox. [easy, problbl]

[frlopes]

Guys. im developing a site, with a list of shops and factories, everything.
I wanna make a search by checkbox, on the site.
by php and mysql.
The logic is simple.
there will be categories and subcategories.
example.
Cat 1 - sub 1 - sub 2 - sub3 - sub4| zone 1 zone 2 zone 3
Cat 2 - sub 1 - sub 2 - sub3 - sub4| zone 1 zone 2 zone 3
Cat 3 - sub 1 - sub 2 - sub3 - sub4| zone 1 zone 2 zone 3
-----------------------------------
the search engine must involve everything.
if i want to search category 1 + cat2sub2and3, in zone 1 = result in a page
if i just want categorie 1 in all zones = result in page.
----------------------------------
you understood?
thanks. sorry for bad english

[bmcoll3278]

It is not to hard but it will take a lot of coding and I or whoever did it would have to access you data base to see how to write the sql query's also would have to know how you want to display it in a table or straight list exc.

[frlopes]

thanks man.
Im gonna make a model of database, and then i post here.
You can help me?
thanks.

[bmcoll3278]

I can try but no promise
That is hours of coding

[frlopes]

oh, really?
i thought it was simple
can you make just a basic one, just for learning process?
if i understand the engine, i think i can make that.
the DB = id - company - type - price
1 - a - blabla - 20
2 - b -tata - 60
3 - c - toto - 20
--------------------
so, if i want to search only companies A in price 20, i can do it. (fill the checkbox and submit) results reported.
--------------------
can do that?
thanks dude. and sorry for inconvenience
.
btw. felipe.romero@hotmail.com, if u can add me, i can try to explain better to u

[bmcoll3278]

Originally Posted by frlopes

oh, really?
i thought it was simple
can you make just a basic one, just for learning process?
if i understand the engine, i think i can make that.
the DB = id - company - type - price
1 - a - blabla - 20
2 - b -tata - 60
3 - c - toto - 20
--------------------
so, if i want to search only companies A in price 20, i can do it. (fill the checkbox and submit) results reported.
--------------------
can do that?
thanks dude. and sorry for inconvenience
.
btw. felipe.romero@hotmail.com, if u can add me, i can try to explain better to u

Do you have the database structure and table names.

Give me a sql files for your data base every thing but your password so I can build the query and I will try. to build the form and php file to do the sql query for you. I will duplicate your database on my server get it working and then send it. so You can just change the password and it should work.