Arrow

how do I 'run' standingssql.sql? | Peter's Sports League Standings | Forum

Back to the sports standings script page
 
Current User: Guest
Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

how do I 'run' standingssql.sql?

Reply to Post Add a New Topic
UserPost

3:43 pm
December 11, 2009


Ryan

Guest

Admittedly I'm not overly familiar with PHP/MYSQL but I can usually make things work. I'm stuck on installation step 3, which requires me to 'Run the SQL commands in standingssql.sql to insert the appropriate database tables.'

Erm, how do I run the .sql? I typed the URL for it into my browser, which came up with a page of commands but didn't 'run' anything.

(right now if I visit standings.php I get the following:

Current Standings

Error in query SELECT seasonname FROM sportsdb_seasons WHERE seasonid = 1 LIMIT 1)

Additionally: I can leave $sportsdb_host = 'localhost'; AS 'localhost' if my DB is located on my server, yes? What if 'standings' folder is placed in sub-folders? Say mysite.com/content/standings, do I have to adjust the code at all or should it work? (I edited user, pass and DB to the user/pass/DB set-up via my Cpanel/MYSQL controller.)

Sorry for the probably beginner questions… thanks.

1:10 am
December 13, 2009


Peter

Admin

posts 732

SQL files are normally imported via the command line or phpMyAdmin. A Google search for "import sql file" or "import sql file phpmyadmin" should help.

5:51 pm
December 13, 2009


Ryan

Guest

Thank you, I was able to discover PHPmyadmin in my Cpanel and now it is working. Just have to play around with the php to customize it for my particular league. Best.

Reply to Post

Reply to Topic:
how do I 'run' standingssql.sql?

Guest Name (Required):

Guest Email (Required):

HTML Editor
Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
12 + 2