Mine

$query = "SELECT id, subject, time, flash, video from news order by news.id desc limit 30";
  $result = mysql_query ($query) or die ("error");
  while ($line = mysql_fetch_array($result)) {
     echo $line["result"];
  }