MySQL and php or perl

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Spud
    Confirmed User
    • Jul 2001
    • 340

    #1

    MySQL and php or perl

    Need some help here
    I'm a do-it-yourselfer so please don't offer to do it for me
    What I have: Unix, MySQL and Perl on the server. A database in Access on my home pc exported out as tab-delimited text.
    What I need: I need to write a query string (I have not a clue but I think I can figure it out once I'm heading in the right direction) that will display selected cells and rotate down one at a time I specify (hourly, daily...)

    I thought I would just whip one out in asp but that's not going to happen
    Any guidance would be great!!!
    thanks
  • Phil21
    Confirmed User
    • May 2001
    • 993

    #2
    huh?

    you want to do what?

    Why is it relevent that you have perl/MySQL and an access database.. that's the part where you lost me.

    -Phil
    Quality affordable hosting.

    Comment

    • TaDoW
      Confirmed User
      • Sep 2001
      • 3875

      #3
      for christ's sake .. we're WEBMASTERS .. that means that if anything we know HTML ... and barely any at that ... the programmer board is just down the street...

      ------------------
      -TaDoW
      I'm really not anyone important...
      -TaDoW

      I've Upped My Standards, Up Yours!

      Comment

      • Matt
        Confirmed User
        • Aug 2001
        • 173

        #4
        Originally posted by TaDoW:
        the programmer board is just down the street...
        http://forums.devshed.com/

        Comment

        • Spud
          Confirmed User
          • Jul 2001
          • 340

          #5
          Sweet! Thanks Matt

          Phil, I was jsut trying to let you know what I had and I thought that letting you know that I had a databade that was exported from Access to tab formated text. I jsut got a PySQL/PHP book by Jay Green and Brad Burgler. So I think I might be bable to bang this out in the next day or so.

          Comment

          • TaDoW
            Confirmed User
            • Sep 2001
            • 3875

            #6
            btw spud ... was just playing around .. I honestly don't know much about that kind of programming :-)


            ------------------
            -TaDoW
            I'm really not anyone important...
            -TaDoW

            I've Upped My Standards, Up Yours!

            Comment

            • Phil21
              Confirmed User
              • May 2001
              • 993

              #7
              Yes.. but what is your actual question?

              did you want to know how to insert the data in tab deliminated format into a MySQL table, "rotate" through mysql records, or.. ?

              feel free to ICQ me if you want. 25285313

              -Phil
              Quality affordable hosting.

              Comment

              • Nbritte
                Confirmed User
                • Sep 2001
                • 689

                #8
                try using the perl functions shift unshift push and pop for real @arrays load the file in an array then just use those function to do what you want.

                Brian

                ------------------
                If I was a real Adult webmaster I would be getting more then 100 hits a day

                SexyCityCash gets in Bed with PornoDan

                Comment

                • Armed & Hammered

                  #9
                  Actually, I would use phpMyAdmin to get your data into your MySQL database. It has an easy to use import feature. Don't even bother with text files unless you want serious server load and super slow performance and the risk of a corrupted text file screwing up your whole system. Once you get the data into your DB, there are about a million ways to rotate the data.

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

                  Comment

                  • Spud
                    Confirmed User
                    • Jul 2001
                    • 340

                    #10
                    Hey! Thanks!!! I've been allover the place today and I found quite a few MySQL sites and I bought a MySQL and php book. They mentioned phpMyAdmin; I just down loaded it and will have to start on it in the morning, Also I found out I might want to restructure my data base I like the way your can link different data bases together. I think this might take me a few days. I knew you guys would come through you would be amazed at how dead some other boards are.. sheesh

                    [This message has been edited by Spud (edited 12-11-2001).]

                    Comment

                    • PornMeister
                      Confirmed User
                      • Aug 2001
                      • 158

                      #11
                      I'm doing quiet a bit of php and mysql programming.
                      just ICQ you if you have any questions 106077052

                      Comment

                      • Spud
                        Confirmed User
                        • Jul 2001
                        • 340

                        #12
                        Hey PornMeister,
                        You have a request waiting for you *icq It's early and I'm caffinated =]

                        Comment

                        Working...