Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder Armondo's Avatar
    Join Date
    Feb 2007
    Posts
    144
    Thanks
    3
    Thanked 0 Times in 0 Posts

    order topics by last updated

    hello! i am totally stumped...i can find NO solution to my problem. i coded my own forum from scratch because i didn't want to use conventional forum software...everything has been going great...but i have run into a snag. the topics are currently displayed according to the $postTIME in a decending fasion...so newer topics go up top. this is not really how i want it. i can't wrap my brain around how i would display the topics like they are here, topics that are posted are bumped to the top. if anyone can help me i would be GREATLY appriciative!

    here is the forum btw: http://flashanims.com/forums/index.php

    oh, and also...if someone could point me i the right direction as to how i would display the last user that posted in a said topic/if the topic has been viewed or not.

    Thanks alot!
    Last edited by Armondo; 08-01-2007 at 01:40 AM.
    ..
    ▲ ▲

  • #2
    Senior Coder
    Join Date
    Mar 2003
    Location
    Atlanta
    Posts
    1,037
    Thanks
    14
    Thanked 30 Times in 28 Posts
    You can't just add a timestamp column that is updated with each new post and use an ORDER `column_name` BY DESC to display the most recent post?

    Additionally, you can have a `viewed` column that is updated whenever a post is read....
    Most of my questions/posts are fairly straightforward and simple. I post long verbose messages in an attempt to be thorough.

  • #3
    Regular Coder Armondo's Avatar
    Join Date
    Feb 2007
    Posts
    144
    Thanks
    3
    Thanked 0 Times in 0 Posts
    well the thing is...i have a timestamp column that is already there, and it has the default set to current timestamp and on auto update properties...and it won't let me make a duplicate of that >_>. what i am thinking of, is if i make a text or int column and use the php date function to manually update it with the date.
    ..
    ▲ ▲


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •