MySQL join problem

[Seaholme]

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!

[jcbones]

You should be accessing that column as: entrantstuff.

 

Or, just remove "AS entrantstuff".