--------------- Added [DATE]1504196589[/DATE] at [TIME]1504196589[/TIME] ---------------
One more question if I may. I added the option to sort by date:
PHP Code:
SELECT dateline, thread.postusername, thread.title AS threadtitle, forum.title AS forumtitle, forum.forumid
FROM vb_thread AS thread
INNER JOIN vb_forum AS forum on thread.forumid = forum.forumid
WHERE thread.sticky = 1
ORDER BY dateline
Is there a way to have it display a readable date instead of the unix timestamp such as YYYY-MM-DD ?
08-30-2017, 06:29 PM
Threaded Mode