Christian F. Posted December 13, 2012 Share Posted December 13, 2012 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. Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399145 Share on other sites More sharing options...
hahaitwork Posted December 13, 2012 Author Share Posted December 13, 2012 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"? Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399148 Share on other sites More sharing options...
Christian F. Posted December 13, 2012 Share Posted December 13, 2012 http://forums.phpfreaks.com/user/27180-jessica/ Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399165 Share on other sites More sharing options...
Barand Posted December 13, 2012 Share Posted December 13, 2012 $mysqli = new mysqli("x","x","x"); There should be 4 parameters, not 3 Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399170 Share on other sites More sharing options...
hahaitwork Posted December 13, 2012 Author Share Posted December 13, 2012 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399174 Share on other sites More sharing options...
Barand Posted December 13, 2012 Share Posted December 13, 2012 Sorry about that the mysqli connect is in my included file. You need $mysqli = new mysqli('host', 'user', 'password', 'database'); before the query. Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399180 Share on other sites More sharing options...
hahaitwork Posted December 14, 2012 Author Share Posted December 14, 2012 (edited) 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 Edited December 14, 2012 by hahaitwork Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399345 Share on other sites More sharing options...
Barand Posted December 14, 2012 Share Posted December 14, 2012 Isn't high_scores_avoidthecars your scores table and not the database? Quote Link to comment https://forums.phpfreaks.com/topic/271524-sorting-loaded-tables-small-fix-needed/page/2/#findComment-1399355 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.