Member Login not connecting to Mysql table correctly, HELP would be appreciated!

[steveo814]

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

[Barand]

Your query has an error. Check what mysql_error() returns.

[Frank_b]

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?

[ginerjm]

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.