$results = mysql_query("SELECT * ,DATE_FORMAT(FROM_UNIXTIME(topics.posted),'%b %D, %Y') as mydate, DATE_FORMAT(FROM_UNIXTIME(topics.posted),'%l:%i %p') as mytime, topics.id AS id_1 FROM topics,posts WHERE topics.forum_id='1' AND topics.id = posts.topic_id AND topics.poster ='treelo' AND posts.poster ='treelo' ORDER BY topics.posted DESC LIMIT 0,10 ") or die(mysql_error());