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
PHP Programmer - interactivetools.com