X-Cart forums

[Jon]

I'm sorry, it's late at night. This one will work, I promise

$productid = func_query_first("SELECT productid from $sql_tbl[products] WHERE 1 ORDER BY productid DESC LIMIT 1"); 
$productid = $productid[productid];

[Chuchen]

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 :

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
#

[Jon]

Don't change this code:

$sql_tbl[products]

[Chuchen]

Everything works great now ! Thank you Jon !

Ah damned, there is a mistake on the top of the home.php page. I can read "If the page is not updated in a 5 seconds, please follow this link: continue >>"

[Jon]

I've tested my exact code on 4.0.x and it should not cause the problem, there must be something else going on, sorry you're on your own from here.

[Chuchen]

No problem Jon, I will try to see if I can do something about that. Thank you again for help