Sorting Loaded Tables :) Small Fix Needed.

[Christian F.]

The query failed, thus it returned a boolean instead of a resource object. Please see the Debugging SQL link in Jessica's signature for detailed instructions on how to handle that.

[hahaitwork]

The query failed, thus it returned a boolean instead of a resource object. Please see the Debugging SQL link in Jessica's signature for detailed instructions on how to handle that.

Sorry, Pretty newbie at this forum.. I searched but didn't find a member with the name "Jessica"?

[Christian F.]

http://forums.phpfreaks.com/user/27180-jessica/

[Barand]

$mysqli = new mysqli("x","x","x");

There should be 4 parameters, not 3

[hahaitwork]

There should be 4 parameters, not 3

uh.. really ? ;o I got select under? to select the database if that is the one you are looking for ?

[Barand]

Sorry about that the mysqli connect is in my included file. You need

 

$mysqli = new mysqli('host', 'user', 'password', 'database');

 

before the query.

[hahaitwork]

ah.. i see, well I tried to add that now and got this..

Warning: mysqli::mysqli(): (42000/1044): Access denied for user 'loff_production'@'%' to database 'high_scores_avoidthecars' in /customers/a/3/f/loff-production.com/httpd.www/avoidthecars/highscore.php on line 9 Warning: mysqli::query(): Couldn't fetch mysqli in /customers/a/3/f/loff-production.com/httpd.www/avoidthecars/highscore.php on line 21 Fatal error: Call to a member function fetch_assoc() on a non-object in /customers/a/3/f/loff-production.com/httpd.www/avoidthecars/highscore.php on line 22

 

Just to update you guys.. It's just the sorting that needs to be done, check out http://forums.phpfreaks.com/topic/271954-loading-only-tables-that-contain-text/ for an update, will close this in a few days. It's easier to follow the other threat

[Barand]

Isn't

high_scores_avoidthecars

your scores table and not the database?