New to PHP <- Simple question

Discussion in 'PHP' started by BOOSTandDESTROY, Jan 21, 2009.

0
  1. #1
    Hello, I am relativley new to php programming. I am programming an oscommerce website and one of the add-ons is requiring me to run an SQL query. Which I do not know how to do.

    What it is telling me to do
    " execute the following SQL script to create the necessary
    tables and configuration files:

    article_manager_sql.sql"

    How do I do this?

    Thank you :D
    Chisholm
     
    BOOSTandDESTROY, Jan 21, 2009 IP
  2. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #2
    you should have a database first.. execute the "article_manager_sql.sql" in the phpmyadmin to create a new schema..
    the oscommerce by default requires that
     
    bartolay13, Jan 22, 2009 IP
  3. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #3
    get into phpmyadmin and click import and choose article_manager_sql.sql
    or open article_manager_sql.sql with notedpad copy the contents and adaptate those queries for a php page and execute it
     
    crivion, Jan 22, 2009 IP
    fundu likes this.
  4. t3nt3tion

    t3nt3tion Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If you are in root, use :

    mysql -u root -p thedb < article_manager_sql.sql
     
    t3nt3tion, Jan 22, 2009 IP