X-Cart forums - How to make product.tpl as the real first page ?

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - How to make product.tpl as the real first page ? (https://forum.x-cart.com/showthread.php?t=19478)

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

Code:

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

$productid = $productid[productid];

:D 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 :oops: )

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

#

Don't change this code:

Code:

$sql_tbl[products]

Everything works great now ! Thank you Jon ! :D

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 >>" 8O

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.

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