July 23rd, 2002, 08:45 AM
|
|
Junior Member
|
|
Join Date: Jul 2002
Posts: 11
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Printing Country name instead of Code
Hey all. I am still having problems with this. This is the last of my problems for this script  . I found ways to get around everything else :-D. Ok, what I am trying to do is print the country name instead of the country value. There are two tables. One is called users, the other is called countried. In the user table,it stores the country code in this format (CA,JM,GB,US,AL etc). In the countries table it is stored as column 0 (name) is the country code and column 1 (value) is the country name. I would like it to print out the country name from the country codes in the Users table. Someone suggested to use a table join, but I tried it and it didnt work. I think it didnt work because of the way the country codes are stored in the Users table. here is the code.
PHP Code:
$a = mysql_query("SELECT Country_Visited FROM neighbors_1 WHERE E_mail = '$email'");
while($b = mysql_fetch_array($a)){
$c = explode(",", $b[0]);
$d = mysql_query("select Country_Visited from neighbors_1 WHERE E_mail='$myrow[3]'");
while($e = mysql_fetch_array($d)){
$f = explode(",", $e[0]);
foreach ($f as $value){
if (in_array($value, $c)){
print("<tr><td bgcolor='$bg'><font size='2'> ");
printf("<a href=\"personal.php?Customer_ID=%s\"> %s %s</a></font>", $myrow[0],$myrow[1],$myrow[2]);
print("</td><td bgcolor='$bg'><font size='2'>");
printf("<a href=\"mailto:%s\">%s", $myrow[3],$myrow[3]);
print("</a></font></td>");
printf("<td bgcolor='$bg'><font size='2'>");
echo $value;
if ($value == CA){
echo "Canada";}
else if ($value == JM){
echo "Jamaica";}
print(" </font></td>");
print("<td bgcolor='$bg'><font size='2'> ");
printf("%s",$myrow[10]);
print("</font></td>");
}
}
}
}
The if statement that tests whether $value == CA or $value == JM dont work. It will only print out Canada if that is the case. It wont ever print out the second country (or any other country but Canada). Thanks for the help
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
