Order by

[deansaddigh]

I want to order my products by the last 10 products entered.

 

hears my sql code

 

  $query = "select product.ProductID, product.ProductName, product.ProductCategory, product.ProductPrice, product.ProductQuantity, product.ProductDescription, image.ImageID, image.ImagePath, image.ImageName, product_image.ImageID, product_image.ProductID
		  FROM product
		  JOIN product_image
		  ON product.ProductID = product_image.ProductID
		  JOIN image
		  ON image.ImageID = product_image.ImageID";

 

How can i do this

[cags]

ORDER BY product.ProductID DESC
LIMIT 10

 

?

[deansaddigh]

Thank youuuuuuu

[cags]

Don't forget to click 'Mark Solved' (button at the bottom left corner of threads you start).