Web Analytics Made Easy -
StatCounter php help about time, date - CodingForum

Announcement

Collapse
No announcement yet.

php help about time, date

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • php help about time, date

    $conected = mssql_query("SELECT memb___id,ConnectTM FROM MEMB_STAT where ConnectStat ='1'");

    this is the code.....
    i wanna change it to something like this.....

    $conected = mssql_query("SELECT memb___id,ConnectTM FROM MEMB_STAT where ConnectTM ='my computer time - 1 hr'");

    which means i want it show all the people which r connected 1hr b4

    any1 know the right code?

  • #2
    in what format time is stored?
    Free php image upload script
    Personal web developing blog

    Comment


    • #3
      welcome here!

      do you want it to be 1 hour earlier, based on the webservers time (so setting the timelimit in PHP) or 1 hour before the db-servers time (so setting it in ms server)? the two don't necessarely will be the same...
      Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

      Comment


      • #4
        i want to be my computer's time - 1hr
        for example now my time is 11am
        i want to show ppl that r connected who connected 1 hr b4 11am
        which mean show all ppl that r connected to svr 10-11am

        Comment

        Working...
        X