jeff5656 Posted January 16, 2011 Share Posted January 16, 2011 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 More sharing options...
jcbones Posted January 16, 2011 Share Posted January 16, 2011 $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']; } Link to comment https://forums.phpfreaks.com/topic/224643-echo-a-name-after-a-join/#findComment-1160388 Share on other sites More sharing options...
Muddy_Funster Posted January 16, 2011 Share Posted January 16, 2011 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' Link to comment https://forums.phpfreaks.com/topic/224643-echo-a-name-after-a-join/#findComment-1160411 Share on other sites More sharing options...
jcbones Posted January 17, 2011 Share Posted January 17, 2011 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. Link to comment https://forums.phpfreaks.com/topic/224643-echo-a-name-after-a-join/#findComment-1160492 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.