Is this correct?

[keepingbusy]

Hi

The following sql statement has been taken from a file called new_products.php which is part of an oscommerce website.

My issue is that I'm trying to set the order to products_id

I have already changed the code but I still get the same result and the product_id is not showing in that order.

select p.products_id, p.products_image,
  p.products_tax_class_id, if(s.status,
  s.specials_new_products_price, p.products_price) as
  products_price from " . TABLE_PRODUCTS . " p left 
  join " . TABLE_SPECIALS . " s on p.products_id = 
  s.products_id where products_status = '1' [b]order by 
  p.products_id[/b] desc limit

I would appreciate some guidance.

Thank you

 

[psymonj]

I could be taking a wild, and uneducated, guess here - but do you not have to place a value with LIMIT or just omit completely?

Simon Clements-Hawes

http://www.silvercoast.co.uk

 

[keepingbusy]

Simon

I think there is an additional piece of code after the [limit], I'll look at it later on today and post back.

Lee

 

[keepingbusy]

The additional code on the end was:

 " . MAX_DISPLAY_NEW_PRODUCTS);

I'm sure this relates to the setting in the oscommerce admin panel.

I would be grateful for any assistance.

 

[keepingbusy]

Found the problem. There was an else statement so I changed the part of the code to:

order by p.products_id limit

Now works perfectly!