Member Avatar for monzu123

Hi,
I am new to PHP and looking for a help to develop below idea with PHP, MySql and Jquery.

[IMG]http://i39.tinypic.com/2cy2xdu.jpg[/IMG]

I want to populate matched people number from database according to dropdown slections. Please check above image to understand what i am talking about.

Any help is very much appreciated. If there is any solution on internet that you already seen, please let me know.

Thanks

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by broj1
Member Avatar for broj1

You will have to query the database for number of matches form your dropdowns using COUNT(*) function. You can use a query in mysql for your example similar to:

SELECT COUNT(*) FROM databasename WHERE Country='France' AND Age BETWEEN 18 AND 40 AND Education='High School' AND InterestA='Reading'

Just to give you an idea.

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.