steveo814 Posted October 1, 2014 Share Posted October 1, 2014 Hey there, First time using MySQL database to connect to a member login. I have a paid subscription site through ccbill which they add the username and logins to. I have setup a database, username and password as well as a table that I have connected correctly "I believe" to my website but get this message: warning: MySQL-fetch_array()expects parameter 1 to be resource, Boolean given in /home.... My table I have setup just has username and password to authenticate the users, which I was told by ccbill is all I need. Maybe I need authentication 1 or 0 etc. Any help on this would be amazing. Spent hours trying to figure this out but nothing. Thanks for your time. Steven Quote Link to comment https://forums.phpfreaks.com/topic/291381-member-login-not-connecting-to-mysql-table-correctly-help-would-be-appreciated/ Share on other sites More sharing options...
Barand Posted October 1, 2014 Share Posted October 1, 2014 Your query has an error. Check what mysql_error() returns. Quote Link to comment https://forums.phpfreaks.com/topic/291381-member-login-not-connecting-to-mysql-table-correctly-help-would-be-appreciated/#findComment-1492487 Share on other sites More sharing options...
Frank_b Posted October 1, 2014 Share Posted October 1, 2014 Looks like your script cannot establish connection with your database server. Did you setup the servername, username, password and databasename correctly in the config of your system? Quote Link to comment https://forums.phpfreaks.com/topic/291381-member-login-not-connecting-to-mysql-table-correctly-help-would-be-appreciated/#findComment-1492495 Share on other sites More sharing options...
ginerjm Posted October 1, 2014 Share Posted October 1, 2014 Your first reply was most accurate. That message constantly appears for every new user of this technology. Show us the code from your query statement, your query execution and your handling of the response/results. As suggested, you should (during development!!) show the results of mysqlI_error when checking if the query runs ok (you do do that ?). And of course you should NOT be using any function starting with MySQL only - that interface is deprecated which you should have noticed in the manual. Quote Link to comment https://forums.phpfreaks.com/topic/291381-member-login-not-connecting-to-mysql-table-correctly-help-would-be-appreciated/#findComment-1492496 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.