Mysql_result is not feeling well....T_T

[PlaGuE]

okay this is really wierd... ive used this function in many scripts...

and yet... its NOT WORKING IN THIS ONE...

i get

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /mounted-storage/home7/sub001/sc13805-XKIN/www/deadlyjynx/etc/private.php on line 9 

when i use this

<?
session_start();
require"conn.php";
 ?>
    <?php
    
    $show = mysql_query("SELECT COUNT(*) AS PM FROM private_message WHERE receiver = '".$_SESSION['user']."'");

$PM = mysql_result($show, 0, "PM");
echo ("(");
if ($PM > 0)

{

    echo "<font color=orange>";

}

echo ("$PM");

if ($PM > 0)

{

    echo "</FoNt>";
}
echo")";
?>

It's really wierd that its not working... any help would be nice in solving this stupid problem.

[visualAd]

That error indicates that the query failed. Is the reciever column numeric? If so, take out the quotes. Also, mysql_error() is your friend

    $show = mysql_query("SELECT COUNT(*) AS PM FROM private_message WHERE receiver = '".$_SESSION['user']."'");

    if (! $show) {
        echo(mysql_error());
        die; 
    }

$PM = mysql_result($show, 0, "PM");