Quick Question

[Ell20]

Hi,

 

Im having a bit of trouble with the following query:

 

$query = "SELECT colour, COUNT(colour),player_id,type, crews.id AS cid FROM dom_london INNER JOIN crews ON dom_london.colour = crews.crewcolour WHERE colour != 'ffffff' GROUP BY colour ORDER BY COUNT(colour) DESC LIMIT 3";
$result = mysql_query($query);
$a = 1;
while ($row = mysql_fetch_assoc($result)) {
$winner.$a = $row['cid'];
$a++;
}
echo $winner1.'<br>';
echo $winner2.'<br>';
echo $winner3.'<br>';

 

I am not getting any errors, its making the space for the echoing of the statements but its not actually displaying anything.

The main part im unsure about is "crews.id AS cid", is this the correct way to put the column name if there is the same column name in the two tables which are being joined?

 

Any help is appreciated

 

Elliot

[unkwntech]

$winner.$a = $row['cid'];

What are you trying to achieve with this line?

[Ell20]

Trying to retreive the ID from the crews table, however bother the crews and dom_london table have the field ID so I therefore used the crews.id AS cid?

 

Not sure if this is correct?

 

Cheers

[samshel]

try

${"winner".$a} = $row['cid'];