How to put the old products in the "New Products" or "Index" page?

[kmosolutions]

Dear,

 

I have a carpet online store.

 

So, when i added the new products such as normall carpets. so they will show up in the front "index" page and even in the "New Products" page.

 

But, i want the products on that pages that i ad already weeks ago. So, how to do it??

Because Kashmir carpets would be nice to show up on the front "index" page and in the "New Products" page.

 

Can someone helps me??

 

Thanks and regards,

Dave.

[burt]

Featured Products : http://addons.oscommerce.com/info/5848

[kmosolutions]

Dear Burt,

 

I installed. But is see errors on my indexpage:

 

 

What i should do iwth the SQL file??

"ALTER TABLE `products` ADD `products_featured` TINYINT( 1 ) NOT NULL AFTER `products_status` ;"

What should i name the table?? any name??

 

Click to see my error:

http://www.royalcarpets.be/shop/index.php

 

 

 

Nieuw(e) artikel(en) voor February

1054 - Unknown column 'p.products_featured' in 'field list'

 

select p.products_featured, p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' order by p.products_featured DESC, p.products_date_added desc limit 6

 

[TEP STOP]

[kmosolutions]

Dear Burt,

 

I installed. But is see errors on my indexpage:

 

 

What i should do iwth the SQL file??

"ALTER TABLE `products` ADD `products_featured` TINYINT( 1 ) NOT NULL AFTER `products_status` ;"

What should i name the table?? any name??

 

Click to see my error:

http://www.royalcarpets.be/shop/index.php

 

 

 

Nieuw(e) artikel(en) voor February

1054 - Unknown column 'p.products_featured' in 'field list'

 

select p.products_featured, p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' order by p.products_featured DESC, p.products_date_added desc limit 6

 

[TEP STOP]

 

 

 

 

 

 

Featured Products : http://addons.oscommerce.com/info/5848

[dickysolo]

Dear Burt,

 

I installed. But is see errors on my indexpage:

 

 

What i should do iwth the SQL file??

"ALTER TABLE `products` ADD `products_featured` TINYINT( 1 ) NOT NULL AFTER `products_status` ;"

What should i name the table?? any name??

 

Click to see my error:

http://www.royalcarpets.be/shop/index.php

 

 

 

Nieuw(e) artikel(en) voor February

1054 - Unknown column 'p.products_featured' in 'field list'

 

select p.products_featured, p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' order by p.products_featured DESC, p.products_date_added desc limit 6

 

[TEP STOP]

 

hello,

what burt means is to update your products table in your DB, with the sql query he provided.