| ||||
SQL: | ||
SELECT SQL_CALC_FOUND_ROWS CONCAT('<img src="',image,'" alt="Thumbnail" />') AS 'Thumbnail', CONCAT('<a target="_blank" href="',url,'">',url,'</a><br /><br />',description) As 'Description', CONCAT('<span style="white-space:nowrap;">',DATE_FORMAT(inserted_on,'%Y-%m-%d %h:%i %p'),'</span>') AS 'Inserted On' FROM ffce_websites LIMIT 0, 5 | ||