What does this query means?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Klen
    • Aug 2006
    • 32235

    #1

    What does this query means?

    I installed one mod on one script and last step is adding sql but i dont know how to add it,i tried with sql query on phpmyadmin but it reports errors.
    Here is info:
    Query: [Select]
    SHOW COLUMNS FROM {$db_prefix}members LIKE '$column'
    Query: [Select]
    SHOW COLUMNS FROM {$db_prefix}log_activity LIKE '$column'
    Query: [Select]
    ALTER TABLE {$db_prefix}log_activity ADD COLUMN $column $spec
  • pythonx
    Confirmed User
    • Aug 2004
    • 430

    #2
    The first 2 just show the columns of the tables which have a name that contains the value of $column.

    The last query adds a new column at the end of the table, named with the value of $column and with datatype specified in $spec.

    Comment

    • Klen
      • Aug 2006
      • 32235

      #3
      Yes but can it be converted to phpmyadmin sql code ?

      Comment

      • Eriic
        So Fucking Banned
        • Jan 2008
        • 2995

        #4
        It shows me tht you don't know what you are doing and need to hire someone.

        Comment

        • ladida
          Confirmed User
          • Nov 2005
          • 2179

          #5
          It's a bit hillarious :P

          "can it be converted to phpmyadmin sql code" ) LOL.
          agentGFY *at* gmail.com

          Comment

          • Ecchi22
            Too lazy to set a custom title
            • Nov 2005
            • 10012

            #6
            "In general, a query is a form of questioning, in a line of inquiry"

            SQL = Structured Query Language

            And yes, you can do that using PHPMyAdmin..

            Comment

            • Bird
              Confirmed User
              • Jan 2005
              • 4365

              #7
              Whats the errors...
              ICQ:268731675

              Comment

              • Klen
                • Aug 2006
                • 32235

                #8
                Originally posted by Eriic
                It shows me tht you don't know what you are doing and need to hire someone.
                Actualy i do know what i doing.I just dont know what fuck that means.

                Comment

                • Klen
                  • Aug 2006
                  • 32235

                  #9
                  I got answer in phpmyadmin query form from author.Problem solved.

                  Comment

                  • Eriic
                    So Fucking Banned
                    • Jan 2008
                    • 2995

                    #10
                    Originally posted by KlenTelaris
                    Actualy i am stupid and don't know what i am doing.I just dont know what fuck life means.
                    It's obvious nimrod

                    Comment

                    Working...