Search Results 2

This example demonstrates how to pagify data, sort it and select it.

FORMfields

Database Error: Table 'terry_forms.ffce_websites' doesn't exist


	SQL:

	SELECT SQL_CALC_FOUND_ROWS id,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