'New for the month of Febuary' Listing all my products on homepage, can I specify one product?

[kawie95]

Right now on my OSC homepage, I have a list of 15 of my newly added products, but I am selling a limited variety of products and I would like to limit this to show just one product, one which I specify. Is this possible? It will be there for months at a time as well.

New Products For February  

Big Freedom 2:15
$20.00 
Prometheus Bound 1:22
$20.00 
Mental Pressure 2:15
$20.00 

String Theory
$20.00 
EthnoColors
$20.00 
FILM & TV ACTION TRAILERS
$50.00 

FILM MUSIC COLLECTION suspense/action/drama
$50.00 
COMMERCIALS vol.3 urban/alternative
$100.00 
COMMERCIALS vol.2 contemporary styles
$100.00

 

I have all that on my homepage now, its cluttered with my products. I want just one. Anyone know how I can control the input of what is shown inside this window, from the admin panel page? Or any way possible to achieve this effect at all?

 

Thanks,

 

 

 

 

 

-Eric Schrader

[Guest]

Right now on my OSC homepage, I have a list of 15 of my newly added products, but I am selling a limited variety of products and I would like to limit this to show just one product, one which I specify. Is this possible? It will be there for months at a time as well.

I have all that on my homepage now, its cluttered with my products. I want just one. Anyone know how I can control the input of what is shown inside this window, from the admin panel page? Or any way possible to achieve this effect at all?

 

get the product id number that tyou want to display.

the product id is displayed in the address bar when you click on the product.

 

inside : include/modules/new_products is the loop that displays you products.

change this :

TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1'

to this :

TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_id =<add the number here without any quotes>

 

keep everything else the same.

all you are adding is :

and p.products_id =<nuimber>

 

corrie

Corrie

[kawie95]

Can I do 2 or more products?

[Guest]

Can I do 2 or more products?

 

 

Sure - use the 'in' clause.

Change this :

TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_id =<add the number here without any

 

to this :

TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_id in (1,2,3,4)

 

Corrie