Member Avatar for thuku

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
  • 111 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by thuku
Member Avatar for Devoted Hosting

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?

Member Avatar for thuku

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.