SQL Query

[Charisma Bypass]

Anyone see anything wrong with this?

$top_info_query = tep_db_query("select max(products_id) as max_id FROM " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$cPath . "' and p.products_status = '1'");

Trying to get the max "product id" on a per category basis.

Error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' categories c where p.products_id = p2c.products_id and p2c.categories_id = c.ca' at line 1

I've become fuddled.  Thanks all.
 

[JasonD]

You don't want a left join, replace that with a comma.

Also max(p.products_id)

[Charisma Bypass]

Thank you very much Jason!
Works perfectly now.  TYVM