Multiple seach issue...

Question

http://www.property30.net/residential Currently i am working these websites but some issue in filter time like if i am select one city like Noida then display one project like Supertech Astralis but if another table hold 6 floor plan of these project on behalf of project id then display its 6 time on recidencial project how to manage diplay only one project Supertech Astralis.. I am attach database table & view...

Akshay Phadke · Answer

you need to modify your code and table structure becuase its getting displayed whose is having 6th floor plans if its having 100 records it will show in your search query 100 you need to modify table structure and code as well

Akshay Phadke · Answer

Raj i had gone through the attachement what you do is create two table first and in the first table make an id as a primary key now save all your data like area zone in this first table now what you do is create another table now if noida area xyz is having 600sq ft area insert that data in second table with their repective ids of their first table with that you can search easily

Raj Jaiswal · Answer

Sorry i am attach wrong file .. please see residencial file

Raj Jaiswal · Answer

Please suggest Aksay ji..