Sorting comments

[jensb]

Hi !

Is there a way to display pic comments with in reversed order .. ie newest first ?

thankful for any help I get

regards Jens

[Abbas Ali]

Edit displayimage.php

Replace (in function html_comments)

Code Select Expand


$result = db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid' ORDER BY msg_id ASC");


with

Code Select Expand


$result = db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid' ORDER BY msg_id DESC");



Abbas

[jensb]

thanx mate