MySQL join problem

Hey all,

Basically I've made a working join query, but for whatever reason that query never fetches the very last piece of information from the database.

I've run into this problem a couple of times now and previously I've just skipped it by adding in a non-essential field to my join query as a sort-of redundant last field, but it would be really nice to know what's causing it and just fix it instead.

// Construct our join query
$query = "SELECT trainingentrants.entrantscore, trainingentrants.entrantid, trainingentrants.eventid, training.gold, training.silver, training.bronze AS entrantstuff".
" FROM trainingentrants, training".
" WHERE trainingentrants.eventid = training.id".
" ORDER BY trainingentrants.entrantscore";

^^ That's an example of one of the queries. The very last thing in the select query - training.bronze - doesn't show. I'm pretty sure it must be an error in the syntax, but can't figure what should go there to get it included.

Thanks in advance!

You should be accessing that column as: entrantstuff.

Or, just remove "AS entrantstuff".