$num_of_product = 10;
$count=0;
$listing_sql = "select p.products_id, pd.products_name, p.products_date_available from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c where p.products_id = p2c.products_id and p2c.categories_id = 1 and p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = ".(int)$languages_id." order by products_date_available desc, pd.products_name";
$listing_split = new splitPageResults($listing_sql, $num_of_product, 'p.products_id');
if ($listing_split->number_of_rows > 0)
{?>
$listing_query = tep_db_query($listing_split->sql_query);
while ($listing = tep_db_fetch_array($listing_query)) {
$count++;?>
=date("Y/m/d", strtotime($listing['products_date_available']))?> |
=$listing['products_name']?> |
}
for($i=0 ; $i <= ($num_of_product-$count) ; $i++)
echo " |
";?>
Fatal error: Call to a member function display_links() on a non-object in /var/www/vhosts/cbsa.com.hk/httpdocs/catalog/news.php on line 56
|