Diff
210
211
211
product.php
  |
165 | 165 | | $Qupdate->bindInt(':language_id', $_SESSION['languages_id']); |
| |
166 | 166 | | $Qupdate->execute(); |
| |
167 | 167 | | } |
 |
| 168 | + | |
| |
| 169 | + | function &getListingNew() { |
| |
| 170 | + | global $osC_Database; |
| |
| 171 | + | |
| |
| 172 | + | $Qproducts = $osC_Database->query('select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from :table_products p left join :table_manufacturers m on (p.manufacturers_id = m.manufacturers_id), :table_products_description pd where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by p.products_date_added desc, pd.products_name'); |
| |
| 173 | + | $Qproducts->bindTable(':table_products', TABLE_PRODUCTS); |
| |
| 174 | + | $Qproducts->bindTable(':table_manufacturers', TABLE_MANUFACTURERS); |
| |
| 175 | + | $Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); |
| |
| 176 | + | $Qproducts->bindInt(':language_id', $_SESSION['languages_id']); |
| |
| 177 | + | $Qproducts->setBatchLimit($_GET['page'], MAX_DISPLAY_PRODUCTS_NEW); |
| |
| 178 | + | $Qproducts->execute(); |
| |
| 179 | + | |
| |
| 180 | + | return $Qproducts; |
| |
| 181 | + | } |
|
168 | 182 | | } |
| |
169 | 183 | | ?> |
|