php - sql connecttion error in the registeration page -

php - sql connecttion error in the registeration page -

i used help page http://youhack.me/2010/04/01/building-a-registration-system-with-email-verification-in-php/ changed database name

database name: 819903 database username: 819903 database password: equal business relationship password database host: localhost

but receive next error after filling registration form hosted @ myproject.6te.net , receive error

database error occured query failed .

you can test @ http://myproject.6te.net/ , give suggestions why error coming inspite of making changes in necessary files. hosting server error or database connection type error although have made changes per requirement?

it's part:

// create sure email address available: 35 $query_verify_email = "select * members email ='$email'"; 36 $result_verify_email = mysqli_query($dbc, $query_verify_email); 37 if (!$result_verify_email) { //if query failed ,similar if($result_verify_email==false) 38 echo ' database error occured '; 39 } 40 41 if (mysqli_num_rows($result_verify_email) == 0) { // if no previous user using email . 42 43 // create unique activation code: 44 $activation = md5(uniqid(rand(), true)); 45 46 $query_insert_user = 47 "insert `members` ( `username`, `email`, `password`, `activation`) values ( '$name', '$email', '$password', '$activation')"; 48 49 $result_insert_user = mysqli_query($dbc, $query_insert_user); 50 if (!$result_insert_user) { 51 echo 'query failed '; - see more at: http://youhack.me/2010/04/01/building-a-registration-system-with-email-verification-in-php/#sthash.v54kddyz.dpuf

change this:

if (!$result_verify_email) { //if query failed ,similar if($result_verify_email==false) echo ' database error occured '; }

into:

if (!$result_verify_email) { //if query failed ,similar if($result_verify_email==false) echo ' database error occured '; echo mysqli_error($dbc); }

and tell me says. athough "no connection database" means database username, password or database not correct.

php