| ||||
SQL: | ||
SELECT SQL_CALC_FOUND_ROWS CONCAT('<a href="?ff_id=',ff_id,'">View</a>') AS ' ',ff_id AS 'ID',doctor_name AS 'Doctor\'s Name', doctor_type AS 'Type of Doctor', insurance AS 'Insurance Accepted',DATE_FORMAT(ff_inserted_on, '%Y-%m-%d %l:%i %p') AS 'Inserted On',DATE_FORMAT(ff_timestamp, '%Y-%m-%d %l:%i %p') AS 'Last Updated' FROM ffce_adoctors LIMIT 0, 20 | ||