problems with MySQL

[philosophology]

Warning: mysql_query() [function.mysql-query]: Access denied for user 'XYZ'@'localhost' (using password: NO) in /home/public_html/j.php on line 29

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/public_html/j.php on line 29

line 29:

mysql_query("UPDATE tblUsers SET usrType = 'user' WHERE usrScreenName='".$_GET['usrScreenName']."'");

What's wrong?

[bradgrafelman]

Did you read the first error message? Should be fairly obvious:

philosophology wrote:

Access denied for user 'XYZ'@'localhost'

Reading further, this:

philosophology wrote:

(using password: NO)

is likely your problem (unless user 'XYZ' truly doesn't have a password to login).