mysql join query

[centenial]

Hello,

I have three MySQL tables:

1. table "listings" (fields below)
   a. listing_number
   b. agent_id
   c. category_id

2. table "agents" (fields below)
   a. id
   b. name

3. table "categories" (fields below)
   a. id
   b. name

I want to display the information in one table, with these columns:
1. Listing Number
2. Agent
3. Category

I want to display the "Agent" and "category" names instead of the agent and category ids. Can this be done with a MySQL Join Query?

Thanks for your help,

[mikawhat]

try this:

SELECT agents.name, categories.name, listings.listing_number 
FROM listings, agents, categories 
WHERE listings.agent_id=agents.id 
AND listings.category_id=categories.id

[centenial]

include 'includes/config.php';
$sql = "select l.id, l.price, l.mls, a.name As agent, c.name As category, s.name As status from listings l
INNER JOIN agents a ON a.id = l.a_id
INNER JOIN categories c ON c.id = l.c_id
INNER JOIN status s ON s.id = l.status";
$res = mysql_query($sql,$conn) or die(mysql_error());

while ($row = mysql_fetch_assoc($res)) {
	echo "	<tr><td>";
	print $row['mls'].'</td><td>'.
	$row['category'].'</td><td>'.
	$row['price'].'</td><td>'.
	$row['agent'].'</td><td>'.
	$row['status'].'</td><td><a href="listing.php?method=edit&id='.
	$row['id'].'">Edit</a> <a href="listing.php?method=delete&id='.
	$row['id'].'">Delete</a></td></tr>';
	}  

echo '</table>';

Why is this not working? Can someone please help?

[nemonoman]

What exactly do you mean by "not working"? are you getting an error message? Or just not the results you expected?