View Single Post
  #2  
Old 10-03-2011, 06:47 AM
  JWait's Avatar 
JWait JWait is offline
 

X-Man
  
Join Date: Nov 2005
Location: California
Posts: 2,440
 

Default Re: need to display recent added products

A lot depends on what is "recent", products added in the last month, last week, last day, last 10 minutes,

Anyway, this question has been asked a million times (well, almost). There are several threads and mods that allow you to have a page that looks like a category page but only has "recent" products. Unfortunately, I haven't found one that works properly for 4.4.x versions of x-cart. X-cart really needs to make this a module.

There is a thread at http://forum.x-cart.com/showthread.php?t=57790 that discusses the latest incarnation of this, and there are probably 3rd party mods that do the same thing as well.

That said, what you are specifically asking about should be pretty simple. You need to search the database for all products with a "add_date" that is newer than "whatever is least recent" (called for in seconds) and output a list of urls to those products. The thread mentioned above should give you some clues on this.
__________________
Two Separate X-Cart Stores
Version 4.4.4 Gold - X-AOM - Vivid Dreams Aquamarine (modified) - Linux
Mods - Newest Products - View All -, and a few others. Numerous upgrades from 4.0.x series.
Integrated with Stone Edge Order Manager + POS

Version 4.1.12 Gold (fresh install) - X-AOM - Linux
Mods - XCSEO free
Reply With Quote