mysql fetch error

Posted by Luke on Stack Overflow See other posts from Stack Overflow or by Luke
Published on 2010-05-15T00:04:11Z Indexed on 2010/05/15 0:14 UTC
Read the original article Hit count: 146

Filed under:
    <? 
    $res = $database->userLatestStatus($u);
    while($row=mysql_fetch_assoc($res)){
       $status=$row['status'];
       echo "$status";
    }
    ?>

This is the code on my page, which is throwing up the following error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource....

The database function:

   function userLatestStatus($u)
   {
       $q = "SELECT status FROM ".TBL_STATUS." WHERE userid = '$u' DESC LIMIT 1";
       return mysql_query($q, $this->connection);
   }

Any ideas what the problem is?

© Stack Overflow or respective owner

Related posts about php