brotherhood_of_LAN - 10:54 pm on Apr 21, 2012 (gmt 0)
Your code is fine, but it only fetches the 1st row where in fact your query returns 3 rows.
You can however fit the result all into one row with something like
SELECT cats.name AS col1,c.name AS col2,p.name aS col3
INNER JOIN country AS c ON c.id = '$data[country]'
INNER JOIN player AS p ON p.id = '$data[player]'
WHERE cats.id = '$data[cat]'
I havent tested it but Im sure you get the idea.
This kind of assumes that your ID columns are unique or you could get unpredictable results, but the query returns the same data as your initial code.