Quote:
Originally Posted by Dave
Just wrap the from_unixtime function around the dateline column.
Code:
SELECT thread.title, post.pagetext, from_unixtime(thread.dateline) AS date
FROM thread
INNER JOIN post ON thread.firstpostid = post.postid
|
Yeah it is work fine.Thank you Dave you are my hero.Now i transfer the threads and the date into another table but if i want to not include some forums threads into the new table.i have the forums ids and i want to except its threads.How can i do that in the same SQL statement?