Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

syntax what is wrong here.


yesudo

Recommended Posts

$get_last_order_id = tep_db_query("select orders_id from " . TABLE_ORDERS . " o, order by o.orders_id desc, limit 1");

 

 

thanx,

Your online success is Paramount.

Link to comment
Share on other sites

thanks mrb.

 

still gettin:

 

Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by o.orders_id desc, limit 1' at line 1

Your online success is Paramount.

Link to comment
Share on other sites

answer:

 

$get_last_order_id = tep_db_query("select orders_id from " . TABLE_ORDERS . " o order by o.orders_id desc limit 1");

Your online success is Paramount.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...