[Resolved] Mysql_fetch_array

[xianzai]

Hi there,

I can't seem to figure out the bug in this code. The db_query($sql) returns the result set.

Any ideas?

$sql = 'SELECT body , sent_time , sent_date , timestamp , from_name , from_email , from_mobile '
. ' FROM messages '
. ' WHERE username = \''.$username.'\''
. ' ORDER BY timestamp DESC LIMIT 0, 30';
$result = $db->db_query($sql);

  if(!$result)
{
  echo "No result";
}
  else
{
  $msg=0;
  while($row = mysql_fetch_array($result, MYSQL_ASSOC) && $msg<5)
    {
      $msg++;
      echo "  <tr>"."\n";
      echo "    <td>"."\n";
      echo "      <font face=\"Verdana\">".$row['from_name']."</font>"."\n";
      echo "    </td>"."\n";
      echo "    <td>"."\n";
      echo "      <font face=\"Verdana\"> and ".$row['sent_date']." ".$row['sent_time']."</font>"."\n";
      echo "    </td>"."\n";
      echo "  </tr>"."\n";
    } 
}

Thanks :-)