| View previous topic :: View next topic |
| Author |
Message |
flowerglen
Joined: 27 May 2003
Posts: 24
|
 Posted: Tue Jan 20, 2004 12:49 am Post subject: newest comments at top |
 |
|
| how do you do this. i know there has to be a way. |
|
| Back to top |
|
 |
gooified
Joined: 09 Jul 2003
Posts: 19
|
| Posted: Mon Jan 26, 2004 12:08 am Post subject: |
|
|
| *bump* I would like to know as well. I just started using pop up comments instead, and for some reason the newest comments are showing at the bottom. argh! |
|
| Back to top |
|
|
gooified
Joined: 09 Jul 2003
Posts: 19
|
| Posted: Mon Jan 26, 2004 12:39 am Post subject: |
|
|
I found it!
find:
| Code: | | $queryc = "SELECT * FROM $tablecomments WHERE comment_post_ID = $id AND comment_content NOT LIKE '%<trackback />%' AND comment_content NOT LIKE '%<pingback />%' ORDER BY comment_date"; |
the last part where it says comment_date, right after that put DESC, so it looks like this:
| Code: | | $queryc = "SELECT * FROM $tablecomments WHERE comment_post_ID = $id AND comment_content NOT LIKE '%<trackback />%' AND comment_content NOT LIKE '%<pingback />%' ORDER BY comment_date DESC"; |
|
|
| Back to top |
|
|
SideSwipe
Joined: 14 Feb 2004
Posts: 1
|
| Posted: Sat Feb 14, 2004 2:14 am Post subject: |
|
|
Gotta love PHP and SQL. 
Thanks - this was just the thing I was looking for, |
|
| Back to top |
|
|
scottie
Joined: 01 Mar 2004
Posts: 1
|
| Posted: Mon Mar 01, 2004 8:37 pm Post subject: |
|
|
Thanks! I was wondering the same thing  |
|
| Back to top |
|
|
hazel
Joined: 20 Jan 2004
Posts: 34
Location: Philippines
|
| Posted: Wed Mar 03, 2004 10:05 am Post subject: |
|
|
| gooified wrote: | I found it!
find:
| Code: | | $queryc = "SELECT * FROM $tablecomments WHERE comment_post_ID = $id AND comment_content NOT LIKE '%<trackback />%' AND comment_content NOT LIKE '%<pingback />%' ORDER BY comment_date"; |
the last part where it says comment_date, right after that put DESC, so it looks like this:
| Code: | | $queryc = "SELECT * FROM $tablecomments WHERE comment_post_ID = $id AND comment_content NOT LIKE '%<trackback />%' AND comment_content NOT LIKE '%<pingback />%' ORDER BY comment_date DESC"; |
|
From what file is this? b2config? |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
