How to sort search with some terms from database?
Posted: Mon Aug 30, 2004 12:13 am
Hi all,
I have search through the forums and tutorial! They are plenty of similar topics, but it is not the answers to my problem.
Well, I have seen lots of websites giving search for their database. Like searching for hotel or restaurants etc..
Lets say, I would like to search with some terms in the result to get fewer results that match my desires more precisely. I will first create a search form with some select options like below.
1. Type keywords
2. Select locations
3. Select what kinds of restarant / how many stars hotels.
4. Select prices less or greater then.
....... can be added more later.
My question is, how to search within the results of a mysql query with php? I have understand how to create tables, but how many tables I should create in my MySQL DB to store the above data? And I want the users to select at least one option.
I just need some Ideas on how to do this. Or maybe any criteria terms or keywords I can search for this. Or if you had any code would like to share please post a reply or email to me.
Many thanks in advance~
I have search through the forums and tutorial! They are plenty of similar topics, but it is not the answers to my problem.
Well, I have seen lots of websites giving search for their database. Like searching for hotel or restaurants etc..
Lets say, I would like to search with some terms in the result to get fewer results that match my desires more precisely. I will first create a search form with some select options like below.
1. Type keywords
2. Select locations
3. Select what kinds of restarant / how many stars hotels.
4. Select prices less or greater then.
....... can be added more later.
My question is, how to search within the results of a mysql query with php? I have understand how to create tables, but how many tables I should create in my MySQL DB to store the above data? And I want the users to select at least one option.
I just need some Ideas on how to do this. Or maybe any criteria terms or keywords I can search for this. Or if you had any code would like to share please post a reply or email to me.
Many thanks in advance~