[RESOLVED] How to call a field inside a different table?

[Padgoi]

Hey guys, I have this query that looks like this:

$rating = mysql_query( "SELECT member_id,field_11 FROM ibf_pfields_content ORDER BY field_11 desc" )

This query calls the member id and field 11 from the table ibf_pfields_content. The problem is that member_id is just a number associated with a user. The member_id field is EQUAL to another field in another table. In other words:

Table Name = ibf_pfields_content
Field name = member_id
Field name = field_11

Table name = ibf_members
Field name = id <b>= member_id field from ibf_pfields_content table</b>
Field name = name

I need to associate the member_id field from ibf_pfields_content to equal the id field from the ibf_members table and then after doing that, I need to call up the name field from the ibf_members table so that instead of showing the user id, it will show the user name.

Can anyone help me with this? I'd be very appreciative. Thanks!

[bpat1434]

You need what's called a SQL JOIN.

The query should be:

SELECT c.`member_id`, c.`field_11`, m.`name`
FROM `ibf_pfields_content` c
JOIN `ibf_members` m
  ON c.`member_id` = m.`id`
ORDER BY c.`field_11` DESC

[Padgoi]

Thanks, topic solved.