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
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.
thanks dude thanks man. Im gonna make a model of database, and then i post here. You can help me? thanks.
more info 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.
