hi I am working in a online shopping website using php, MySql. And I had a detail database with me . Let me give some details
I had columns in my table.
ie 1. name of the product ( eg : 1 gb pendrive)
2. Brand
3. warrenty
4. category ( eg computer )
5. MRP
6. Price
At first my client said user will search items by category . And that is easy something like this mysql_query("SELECT * from database where category='computer'") Now I need to add little more advanced that user need to search items by any keyword.
I think results will got from the first column.
Please help me for making right query here for searching.. Please help me...
Regards
Rajeesh