note 94049 deleted from function.mysql-real-escape-string by danbrown

From: Date: Tue, 13 Oct 2009 21:30:46 +0000
Subject: note 94049 deleted from function.mysql-real-escape-string by danbrown
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-161705@lists.php.net to get a copy of this message
Note Submitter: ben_johnson1991 at hotmail dot co dot uk ---- Hey, I'm reasonbly new to using this function. I have scripted it as so // Connect to database include_once "scripts/connect_to_mysql.php"; $emailCHecker = mysql_real_escape_string($email1); $emailCHecker = eregi_replace("`", "", $emailCHecker); // Database duplicate e-mail check setup for use below in the error handling if else conditionals $sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$emailCHecker'"); $email_check = mysql_num_rows($sql_email_check); however, when i run this form the following error messages appear in the browser. Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'bensbox'@'lotus.x10hosting.com' (using password: NO) in /home/bensbox/public_html/socialnetwork_root_directory/register.php on line 72 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/bensbox/public_html/socialnetwork_root_directory/register.php on line 72 Warning: mysql_query() [function.mysql-query]: Access denied for user 'bensbox'@'lotus.x10hosting.com' (using password: NO) in /home/bensbox/public_html/socialnetwork_root_directory/register.php on line 75 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/bensbox/public_html/socialnetwork_root_directory/register.php on line 75 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bensbox/public_html/socialnetwork_root_directory/register.php on line 76 I thought it would simply because me connect_to_mysql.php was incorrect, but that is not the case. I have about 20 of this same error. could anyone help? Cheers :)

« previous php.notes (#161705) next »