[willettmatter]

this is my test :
$uname="bill";
$pword="fred";

$creds=sprintf("uname='%s', pword='%s'", mysql_real_escape_string($uname), mysql_real_escape_string($pword));

print($creds);

here is the errors:
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'a1345185'@'localhost' (using password: NO) in /home/a1345185/public_html/register/test.php on line 5

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/a1345185/public_html/register/test.php on line 5

What does it mean about the password?
Is there something else I'm missing?

[you10]

1. Your connecting to localhost not the mysql server, you need to use mysql*.000webhost.com (replace the * with the mysql server you are on)
2. Databases have passwords, this will be the one you entered when you setup the database.

[willettmatter]

This function has nothing to do with the data base. I only have the scripting that you see there.

Are you required to connect to the db to use this function?

[Firebirds]

Your error means that you need to use a password, (the one you made while making the db) to login. Also, you cannot login at "localhost", you must use something that looks like mysql*.000webhost.com

[grace1004]

To use mysql_real_escape_string() function, you need to add database connection script as shown below.

PHP Code:

<?php
$conn = mysql_connect("mysql#.000webhost.com", "a336xxxx_test","******") or die(mysql_error());
mysql_select_db("a336xxxx_test", $conn);

$uname="bill";
$pword="fred";

$creds=sprintf("uname='%s', pword='%s'", mysql_real_escape_string($uname), mysql_real_escape_string($pword));

print($creds);
?>

I tested a code similar to above in my localhost server, and it works fine.

Just for your information:

Even if "mysql#.000webhost.com" is used as host in database connection script, the error message
will show something like 'a1345185'@'localhost' if there's something wrong with the script.
In other words, it's normal to have 'localhost' in the error message.