Tweet
eigentlich sollt diese $sql auch das Datum umwandel:
Aber irgendwie kommt immer nur "Y-m-d H:i:s" raus, statt "d.m.y H:i:s".
PHP-Code:
$sql_id = mysql_query ("SELECT a.*, count(b.id) AS hatantwort,
DATE_FORMAT(a.post_date,'%d.%m.%y %H:%i:%s') AS p_date
FROM $table AS a LEFT JOIN $table AS b ON b.post_parent=a.id
WHERE a.post_forumid='$forumid' AND a.post_parent='$parent'
GROUP BY a.id ORDER BY a.post_date DESC LIMIT $offset,$diff")or
die(mysql_error());
Moderator
Kommentar