') AS 'Thumbnail',
CONCAT('',url,'
',description) As 'Description',
CONCAT('',DATE_FORMAT(inserted_on,'%Y-%m-%d %h:%i %p'),'') AS 'Inserted On'
FROM ffce_websites
";
// Create the SearchResultsField and add it to our FfForm
$ffForm->addField(new SearchResultsField("websites", "Websites", $sql, 5));
// Enable column sorting
$ffForm->formFields["websites"]->tableSet->enableSort = true;
// Capture and process any button presses
$ffForm->getParameters();
?>
Search Results Example