MYSQL Fetch Array

[Ashoar]

I am having a problem with the mysql_fetch_array funtion.

 

$sql = mysql_query ("SELECT pm_count FROM users WHERE username='$user'");
        $row = mysql_fetch_array ($sql);
        $pm_count = $row['pm_count'];

 

I have that piece of code running but everytime i load the page i get this php error

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a4588739/public_html/inbox.php on line 21"

 

I have checked over and over and dont know why it will not work.

 

Anyone have a solution.

[wildteen88]

That error usually indicates there was a problem with your query. Change

$sql = mysql_query ("SELECT pm_count FROM users WHERE username='$user'");
        $row = mysql_fetch_array ($sql);
        $pm_count = $row['pm_count'];

to

$sql = "SELECT pm_count FROM users WHERE username='$user'";
$result = mysql_query($sql) or die('Query error:<br />' . $sql . '<br />' . mysql_error());

$row = mysql_fetch_array ($result);
$pm_count = $row['pm_count'];

[Ashoar]

Thankyou for your help.