Jump to content

echo a name after a JOIN


jeff5656

Recommended Posts

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. 

Link to comment
https://forums.phpfreaks.com/topic/224643-echo-a-name-after-a-join/
Share on other sites

$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'];
}

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.