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.
thuku
0
Newbie Poster
Recommended Answers
Jump to PostAssuming 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 …
All 2 Replies
Devoted Hosting
0
Light Poster
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?
thuku
0
Newbie Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.