echo a name after a JOIN

[jeff5656]

When I have more than one table i don't know how to echo out a field if it is the same in both fields.  here's my code and I want to echo out the id from the people table:

$query =  "SELECT * FROM people INNER JOIN ratings ON people.id = ratings.rater_id AND ratings.event_id = '$eventid' AND ratings.complete = 'n' "; 

$result = mysql_query($query);
while ($row=mysql_fetch_assoc($result)){
echo $row['people.id'];
}

 

I tried  $row['people.id'] but it was blank. 

[jcbones]

$query =  "SELECT people.id AS pID, ratings.* FROM people INNER JOIN ratings ON people.id = ratings.rater_id AND ratings.event_id = '$eventid' AND ratings.complete = 'n' "; 

$result = mysql_query($query);
while ($row=mysql_fetch_assoc($result)){
echo $row['pID'];
}

[Muddy_Funster]

I would give serious considerastion to revising your SQL.  Somthing like this would make more sense:

SELECT id FROM people INNER JOIN ratings ON (people.id = ratings.rater_id) WHERE ratings.event_id = '$eventid' AND ratings.complete = 'n'

 

[jcbones]

I would give serious considerastion to revising your SQL.  Somthing like this would make more sense:

SELECT id FROM people INNER JOIN ratings ON (people.id = ratings.rater_id) WHERE ratings.event_id = '$eventid' AND ratings.complete = 'n'

 

 

id would be ambiguous in your statement.  MySQL wouldn't know if it was people.id or ratings.id that you wanted.