MySQL grab info from table and relate

[Anon]

There are two tables that I have. One named Countries and another named users. In the Counrties database, I have 2 columns (name and value). In name it gives the country code, and the value is the country's name. When my users first sign on, they create a profile. When they choose which countries they have visited, it stores it in User (under Country_Visited) as the values under the name column. How can I print the actual value using php and html?

THANKS
Patrick

[Anon]

So, why do you store multiple values in a column? It goes against the grain of all sound database design and makes quering very complicated.

create an additional table with two columns, one to identify a user, one for identifying the country. Store each combination of user and country as separate records.

To get all countries a user has visited, use the following query

select username,countryName
from users u left join countriesVisited cv
on u.userid = cv.userid
left join countries c
on cv.countryid = c.countryid

I did not follow your naming standard as I thought it counterintuitive.