Original geschrieben von Offe1
wie lugi schon sagte!
Offe
wie lugi schon sagte!
PHP-Code:
$result = mysql_query("SELECT P.date, P.userid AS p_userid,
DATE_FORMAT(T.date,'%d.%m.%Y') AS t_date, DATE_FORMAT(T.date,'%H:%i:%s') AS t_time,
DATE_FORMAT(P.date,'%d.%m.%Y') AS p_date, DATE_FORMAT(P.date,'%H:%i:%s') AS p_time
FROM board_threads T INNER JOIN board_posts P USING(bid) WHERE T.bid='".$id."' ORDER BY p_date, p_time DESC") or die (mysql_error());
Kommentar