How to count the number of new Ads in the last 24 hours?

Last post 11-08-2007 11:41 AM by tianjie. 2 replies.

Sort Posts:

  • How to count the number of new Ads in the last 24 hours?

    11-08-2007, 10:44 AM
    • Member
      2 point Member
    • tianjie
    • Member since 08-13-2007, 12:28 AM
    • Posts 15

    As titled, i just want to add a label showing how many new Ads were posted within the last 24 hours. Could anybody let me know how to do that?

  • Re: How to count the number of new Ads in the last 24 hours?

    11-08-2007, 11:29 AM
    • Member
      348 point Member
    • cheetahtech
    • Member since 02-28-2007, 6:33 PM
    • The States
    • Posts 130

     you can do one of two things,

     

    You can either insert a line into a database witha  time and date stamp and select count * from XXX where Datetime.hours < 24 or something like that.

     

    You could open up an file you keep on the server, keep 1 digit in there and add one each time a add is displayed and pull from that number when the label shows the number.

     

    I would suggest SQL server route if you have that ability. 

     

    Let me know if you need help. 

    Please remember to mark your post as "Resolved" when it is solved, and mark as "Answer" the post(s) that solved it!
  • Re: How to count the number of new Ads in the last 24 hours?

    11-08-2007, 11:41 AM
    • Member
      2 point Member
    • tianjie
    • Member since 08-13-2007, 12:28 AM
    • Posts 15

    Thanks for your quick reply. I am totally a newbie to .net. So i have no idea how to achieve what you said. Could you kindly provide more detailed instruction? Thank you very much.

Page 1 of 1 (3 items)