Below is the code that will give me ASC to DESC for the comments so that it shows new comments first then old ones. However
$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").$additional_sql."
FROM ".COMMENTS_TABLE." c
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = c.user_id)
WHERE c.image_id = $image_id
ORDER BY c.comment_date DESC
LIMIT $offset, $commentperpage";]
The code highlighted red above was replaced by the code below because of Ajax commenting 4.5 MOD, do i revert it back to code above?...
WHERE c.image_id = $image_id
ORDER BY c.comment_date ".(COMMENTS_ORDER ? "DESC" : "ASC")."";
, so do i now revert it back? Thanku Vano, you are a good person.