mysql query generator tool??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mrthumbs
    salad tossing sig guy
    • Apr 2002
    • 11702

    #1

    mysql query generator tool??

    is there some sort of simple tool that can do this:

    i insert a few variables
    testa
    testb
    testc

    and the tool auto generates this query:
    $query=mysql_query("insert into whatever (testa, testb testc) values ('$testa','$testb','$testc')");

    which i can simply cut and paste into my php script..

    Its a bitch creating those queries with tables over
    30 fields...

    Otherwise ill build it myself but maybe......???
  • senseidru
    Confirmed User
    • Sep 2002
    • 1767

    #2
    I know phpmyadmin has a tool for generating queries on sql tables. But I love to do it manually.

    Comment

    • sexsup
      Confirmed User
      • Feb 2004
      • 3004

      #3
      Originally posted by senseidru
      ...But I love to do it manually.
      It's a sort of perversion

      Comment

      • grumpy
        Too lazy to set a custom title
        • Jan 2002
        • 9870

        #4
        contact me...i can do that :-)
        Don't let greediness blur your vision | You gotta let some shit slide
        icq - 441-456-888

        Comment

        • FiReC
          Confirmed User
          • Jan 2002
          • 2350

          #5
          MS access has the ability to build queries using their gui.
          www.nubilefilms.com | www.nubiles.net | www.anilos.com | tubescript.nubiles.net | icq4162727

          Comment

          • Repetitive Monkey
            Confirmed User
            • Feb 2004
            • 3505

            #6
            I'll make it in PHP if you wish... Would take me a whole 30 seconds.

            Comment

            • mrthumbs
              salad tossing sig guy
              • Apr 2002
              • 11702

              #7
              replies came in a bit late so i already made my own tool
              to generate INSERT and UPDATE queries..

              this is going to be a big time saver!!

              Comment

              • Repetitive Monkey
                Confirmed User
                • Feb 2004
                • 3505

                #8
                Originally posted by mrthumbs
                replies came in a bit late so i already made my own tool
                to generate INSERT and UPDATE queries..

                this is going to be a big time saver!!
                Can you please donate some postcounts to me?

                Comment

                • senseidru
                  Confirmed User
                  • Sep 2002
                  • 1767

                  #9
                  Originally posted by sexsup
                  It's a sort of perversion

                  Comment

                  • xroach
                    Confirmed User
                    • Feb 2002
                    • 963

                    #10
                    weak

                    Comment

                    Working...