View Single Post
  #12  
Old 01-29-2006, 10:11 PM
 
Chuchen Chuchen is offline
 

Advanced Member
  
Join Date: Dec 2005
Posts: 37
 

Default

This time I've got this message :

"If the page is not updated in a 5 seconds, please follow this link: continue >> INVALID SQL: 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 'WHERE 1 ORDER BY productid DESC LIMIT 1' at line 1
SQL QUERY FAILURE: SELECT productid from WHERE 1 ORDER BY productid DESC LIMIT 1


If the page is not updated in a 5 seconds, please follow this link: continue >>"

(sorry to bother you Jon )

This is the code :

Code:
define('OFFERS_DONT_SHOW_NEW',1); require "./auth.php"; $productid = func_query_first("SELECT productid from $sql_tbl[xc_products] WHERE 1 ORDER BY productid DESC LIMIT 1"); $productid = $productid[productid]; # # Put all product info into $product array #
__________________
xcart v4.1.1 [MacOS] / x-aom-4.1.1 / x-offers-4.1.1 / x-rma-4.1.1 / X-Magnifier-4.1.1 (and... happy with x-Cart !)
Reply With Quote