how do I 'run' standingssql.sql? | Peter's Sports League Standings | Forum
Back to the sports standings script page
3:43 pm
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.