MYSQL : problem with mysql_query

Question

I need your help. What does this mean?

Warning: mysql_query() [function.mysql-query]: Access denied for user 
        'ODBC'@'localhost' (using password: NO) in 
        C:\xampp\htdocs\THESIS\std_results.php on line 4

Warning: mysql_query() [function.mysql-query]: A link to the server could 
        not be established in C:\xampp\htdocs\THESIS\std_results.php on line 4
        Access denied for user 'ODBC'@'localhost' (using password: NO)

This is the code that I used when I got that message.

$answer = mysql_query("SELECT * FROM tbl_answers") or die(mysql_error());
$r = mysql_fetch_assoc($answer);  
echo $r['id_exp'];

This is my first time encountering this kind of problem. Can someone explain to me how I can fix this?

Sarfraz Sarfraz · Accepted Answer · 2011-02-10T18:44:09

The error means you are not connected to mysql. You need to connect to mysql before running your query:

Check out:

Connect to MySQL Database

Your code should be like this:

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'dbname';
mysql_select_db($dbname);

$answer = mysql_query("SELECT * FROM tbl_answers") or die(mysql_error());
$r = mysql_fetch_assoc($answer);
echo $r['id_exp'];

MYSQL : problem with mysql_query

2 Answers