| ||||
| SQL: | ||
| SELECT SQL_CALC_FOUND_ROWS CONCAT('<a href="?__id=',__id,'">View</a>') AS ' ',CONCAT('<a href="?__id=',__id,'&action=edit">Edit</a>') AS ' ',CONCAT('<a href="?__id=',__id,'&action=delete">Delete</a>') AS ' ',__id AS 'ID',doctor_name AS 'Doctor\'s Name', doctor_type AS 'Type of Doctor', insurance AS 'Types of Insurance Accepted',DATE_FORMAT(__inserted_on, '%Y-%m-%d %l:%i %p') AS 'Inserted On',DATE_FORMAT(__timestamp, '%Y-%m-%d %l:%i %p') AS 'Last Updated' FROM ffce_adoctors LIMIT 0, 5 | ||