0

I wana perform a search on my mysql database.i want to search 4 categories at the same time e.g a person who wants to search for a nike shoe, size no 7, in africa, in kenya.
How will i go about dat.

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by thuku
0

Assuming I read your post correctly, wouldn't it just be basic SQL?

For example:

SELECT * FROM table WHERE shoe = 'Nike' AND size = '7' AND continent = 'Africa' AND country = 'Kenya'

Where exactly are you struggling? Is it with how to carry out a SQL query in PHP, or the SQL itself?

0

thanx for the reply.i just had a mentality that it was gona be some tuff php.maybe arrays.but i agree with your anwer.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.