my sql server is broken :(

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Marcus
    Confirmed User
    • Jul 2001
    • 3472

    #1

    my sql server is broken :(

    I keep using the getdate() function but I still don't have a date.

    what should I do?
  • Speedy26
    Confirmed User
    • Apr 2001
    • 950

    #2
    try adultfriendfinder
    http://www.amberscash.com webmaster {at} crazynakedchick [dot] com

    Comment

    • big perm
      Registered User
      • Oct 2001
      • 37

      #3

      Comment

      • Naughty
        Confirmed User
        • Jul 2001
        • 6487

        #4
        Originally posted by Speedy26:
        try adultfriendfinder
        Too funny



        ------------------

        - the Official TGP2 Counter --> signup now for realtime stats, toplists and more...!
        - Submit Your Galleries Here to The Naughty Daily
        - EraserCash - $35/signup, unique commissionprogram
        seks.ai for sale - ping me

        Comment

        • FADE19
          Snow's Parole Officer
          • Sep 2001
          • 1161

          #5
          I would do it in the script and then submit along with whatever else you are uploading to the DB, I am assuming because you are using SQL server it is Micoshit sooo...in ASP do this:

          inpu typ="text" NAME="time" value="<4=now()4"


          replace the 4's with percentage signs...this is just a temp fix....I have been doing PHP for awhile so my ASP is a little rusty

          [This message has been edited by FADE19 (edited 10-24-2001).]

          Comment

          • awechen
            Confirmed User
            • Oct 2001
            • 162

            #6
            Originally posted by Marcus:
            I keep using the getdate() function but I still don't have a date.

            what should I do?

            ok u using php ?
            if yes ..
            getdate returns an associative array containing the date information of the timestamp, or the current local time.
            u u need the system time now !
            which format u need ?

            or u need the timestamp ?
            or u need to convert the timestamp to a 'real' time ?




            ------------------
            "Shock your systemadministration! Read manual-pages!"
            ah you have been blessed with 72 virgins?

            Comment

            • pipp
              Confirmed User
              • Oct 2001
              • 1185

              #7
              setlocale ("LC_ALL");
              #It the server is in another time zone
              $time_offset="+0";
              $date_format= "%A %d %b, T. %H:%M";

              $sql= "SELECT UNIX_TIMESTAMP(insertedDate) as insDate";

              $date = strftime($date_format,$myrow["insDate"]);

              Comment

              • Robert
                Ask me about negative cash flow
                • Feb 2001
                • 533

                #8
                Originally posted by Speedy26:
                try adultfriendfinder


                SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

                Comment

                • awechen
                  Confirmed User
                  • Oct 2001
                  • 162

                  #9
                  Originally posted by pipp:
                  [B]
                  $sql= "SELECT UNIX_TIMESTAMP(insertedDate) as insDate";

                  heeh this suxx is it a remote host sql )

                  [B]


                  ------------------
                  "Shock your systemadministration! Read manual-pages!"
                  ah you have been blessed with 72 virgins?

                  Comment

                  Working...