Some help with some MySQL and PHP code please

[fido_glc]

Let's say that I have the following 4 tables in my database:

users (id, username)
products (id, name, image)
selling (sellid, productid, price)
sold (userid, productid, sellid)

I want so select the first 5 rows from the "sold" table and to retrieve the username, the product name, the product image and the product price.

The username will be retrieved by comparing sold.userid with users.id.

The product name will be retrieved by comparing sold.productid with products.id and taking the name.

Same for the product image.

And the product price will be retrieved by comparing sold.sellid with selling.sellid and taking the price.

What would be the MySQL code for retrieving the 5 rows with the appropriate information and the PHP code to echo this information ?

Thank you.

[sneakyimp]

SELECT s.id as sold_id, u.id as user_id, p.id as products_id, p.name as product_name, p.image as product_image
FROM sold s
INNER JOIN users u
ON u.id=s.userid
INNER JOIN products p
ON p.id=s.productid
LIMIT 5;

something like that.