viewing data problem

i have two tables as below:

table USER(
id char(10)
name char(20)
email char(20)
country char(20)
);

table COUNTRY(
country_id char(20),
country_name char(20)
);

the country_id is store into the USER table as it selected

so next, i want to view my data,

<?
mysql_connect("localhost", "root");
@mysql_select_db("user") ;
$result = mysql_query("select * from user");
$row = mysql_fetch_array($result);
?>
echo "Name: ".$myrow["name"];
echo "email: ".$myrow["email"];
echo "country: ".$myrow["country"];

that's the problem, it show the country_id not the country_name, so how i query from them to view the country field is country name

Change the code on the mysql_query line to something like :

It's probably a good idea to change the user.country and country.country_id fields to be integers.. faster lookup.

Hope this helps

ha..ha...thanks CmdrDats ur help.....it worked now....thanks

only a pleasure to be of assistance ;)