Display product after 2012

3 posts by 2 authors in: Forums > CMS Builder
Last Post: April 3, 2015   (RSS)

By Tom - April 2, 2015

Hello,

I have a field named date_added

In the listing viewer,

I intend to display all the product after 2012 only.

This is my code 

<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block to the TOP of your page BEFORE anything else. */
require_once "init.php";
list($listingRecords, $listingDetails) = getRecords(array(
'tableName' => 'listings',
'joinTable' => 'homepages',
'perPage' => '10',
'where' => "date_added_min='2012'",
));

?>

However, it said

MySQL Error: Unknown column 'date_added_min' in 'where clause'

Please advice.

Thanks a lot

By gregThomas - April 3, 2015 - edited: April 3, 2015

Hi Tom,

Good to see you've resolved the problem, let me know if you have any other questions.

Cheers,

Greg

Greg Thomas







PHP Programmer - interactivetools.com