Brown, Craig wrote:

I am trying to update a database that I use to store user names and the hashed values of passwords. The database name is Login, the table is "users".

I have the following commands in my php file.

@ $db=mysql_pconnect('localhost','apache','password'); mysql_select_db('Login'); $query="UPDATE users set pw='$hash' WHERE id='$user'"; $results = mysql_query($query);

The result is always false. If I enter the value of $query into a console (such as mysqlcc). The command works fine. Any ideas?



Actually, you are entering at the console the value you are hoping $query will have. You never test to see what $query actually is or what is the error. Do you know for sure that the correct value of $user is being parsed? Do you even know that the script made a valid connection and db selection?

Put an ECHO $query; statement and some other error checking in there and quit tearing out your hair over assumptions that may be wrong.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to