How to make product.tpl as the real first page ?

Chuchen · #1 01-25-2006, 12:28 AM

I would like to sell only one product on a website (one product for one month, one another product for the next month, etc.).

So please, how to make product.tpl as the real first page to show the last and only one product I sell ? This way, my customer could see directly product.tpl page at www.mynextsite.com (I don't like to use a redirection).

I can't find this information on the forum, so thank you very much if it is possible

[/b]

pauldodman · #2 01-25-2006, 12:37 AM

One way to do this would be, having removed index.html index.php is now your new start page.
Now edit index.php and change home.php to the path of your product.
e.g.

Code:

header("Location: product.php? productid=76&cat=103&page=1&featured");

Chuchen · #3 01-25-2006, 09:19 AM

Thank you for your answer

Unfortunately, I don't want to do redirection. Do you think I can call the product.php page : index.php or home.php ?

Jon · #4 01-25-2006, 09:38 AM

Make a copy of product.php and rename it home.php

In home.php after the include of auth.php put:

$productid = "X";

Where X is the productid of the product you want to display.

Chuchen · #5 01-25-2006, 11:58 AM

Thank you very very much Jon, I will try tomorrow

Chuchen · #6 01-29-2006, 09:04 AM

After few tests, it works great ! Thank you again. Now, I'm trying to write a little bit of PHP to get always the last product ID instead of write it each time on the new home.php file.

Do you think it's a good idea ?

Jon · #7 01-29-2006, 08:07 PM

[Removed]

Chuchen · #8 01-29-2006, 09:35 PM

Thank you Jon !

I must write your code under "define('OFFERS_DONT_SHOW_NEW',1);
require "./auth.php";" isn't it ?

Jon · #9 01-29-2006, 09:51 PM

[Removed]

Chuchen · #10 01-29-2006, 09:57 PM

I've got this message :

"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 DESC LIMIT 1' at line 1
SQL QUERY FAILURE: SELECT productid from WHERE 1 ORDER BY DESC LIMIT 1

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

and after I can read this message on the home.php page :

Access denied !
You are not allowed to access that resource!
Error ID: 33

Maybe the mistake come from the "where 1" ?