Arrow

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

Back to the sports standings script page

Please consider registering
guest

Log In

Lost password?
Advanced Search

— Forum Scope —

  

— Match —

   

— Forum Options —

   

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
how do I 'run' standingssql.sql?
December 11, 2009
3:43 pm
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.

December 13, 2009
1:10 am
Peter
Admin
Forum Posts: 841
Offline

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.

December 13, 2009
5:51 pm
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.