ok, strange error I have:
http://www.irishair.org.uk/nvas/members ... vid=200000
this script works, however, I have an error in the mysql_fetch_array() queries used in the following code:
$countrycode = $row["country"];
$query = "select * from nvas_country where code='$countrycode'";
$country = mysql_query($query);
while ($row2 = mysql_fetch_array($country))
$country = $row2["country"];
$division = $row["division"];
$query = "select * from nvas_divisions where code='$division'";
$division = mysql_query($query);
while ($row3 = mysql_fetch_array($division))
$division = $row3["division"];
I know this code works, as it basically fetches the details "United Kingdom" out of two seperate tables (as division can be different to country).
http://www.irishair.org.uk/nvas/members ... vid=200002
It also fetches a different country here.
Anyone got any suggestions?