MYSQL problem

[robert_gsfame]

if i have 3 checkboxes

-Switzerland

-Australia

-Brazil

 

and mysql will be based on what has been chosen,

 

if user chose Australia, so query will be

SELECT name FROM table1 WHERE country='Australia'

 

How bout if he chose 3 countries at the same time, how the query will be so that the output will be all name who lives in Australia, All name who lives in Brazil and all name who lives in Switzerland ??

 

thx

 

[kickstart]

Hi

 

You would need to build it up in php, but easiest would be to use:-

 

SELECT name FROM table1 WHERE country IN ('Brazil','Switzerland')

 

That said one thing to watch out for is duplicate names. OK, not that likely with countries but very likely with town names. As such might be best to have a table of countries, and when you display the drop down list box you display the name but return a value that is the unique id of the country.

 

All the best

 

Keith

[robert_gsfame]

yes i know using IN, but how do i retrieve the data from database using mysql_fetch_array??

[robert_gsfame]

okay i got it, i forgot to loop it