Query not returning any results...

[Chris]

Hi all -

Hope you can help me with this SQL / PHP problem.

I have the following tables with (in brackets) the following columns:

PLAYER (playerid, forename, surname, birthdate, birthplace)
PLAYERHISTORY (playerhistid, playerid, boughtfor, joined_date)
PLAYERAPPS (playerappsid, playerhistid, apps, goals)

In 'showplayers.ph p' I have a select box where users can select the
surname of a player. The next page will then (theoretically) show all
the players details.

I've managed to get data from the PLAYER table using the following SQL
query at the top of the PHP page:

$query = "SELECT *, DATE_FORMAT(bir thdate, '%d/%m/%Y') AS birth FROM
player WHERE playerid='{$_PO ST['interest']}'";
$result = mysql_query($qu ery)
or die ("Couldn't execute query");
$row = mysql_fetch_arr ay($result);

However, I'm running into troubles when I'm trying to get details from
the PLAYERHISTORY table. I've written another SQL query to select data
from the PLAYERHISTORY table, according to what player has been
selected.
$query2 = "SELECT *, DATE_FORMAT(joi ned, '%d/%m/%Y') AS joined FROM
playerhistory LEFT JOIN player ON playerhistory.p layerid =
player.playerid ";
$result2 = mysql_query($qu ery2)
or die ("Couldn't execute query2");
$row2 = mysql_fetch_arr ay($result2);

However, $query2 doesn't return any results - despite there being data
in the database it should be returning.

Can anyone advise whether there is a problem with my SQL query, or is
something else. I've double checked the PHP code, and this is fine.

Any help greatly appreciated.

Regards,

Chris