sql trouble

[phlow]

i use the following code in serveral documents, why doesn't it work in some documents?

Error-Message:
Warning: Supplied argument is not a valid MySQL result resource in Welcome.php3 on line 42

Code:
<?php
$db = mysql_connect("localhost", "root", "password");
mysql_select_db("news",$db);
$result = mysql_query("SELECT * FROM news",$db);
if ($myrow = mysql_fetch_array($result))
{
echo "<br>";

   do
   {
   ---commands---
   }
   while ($myrow = mysql_fetch_array($result));


 } 

 else     
 {
         echo "ERROR: no news were found!";   
 }

?>

[Anon]

$result = mysql_query("SELECT * FROM news");

this to me is the problem. you already selected the database in the mysql_select_db so you don't need it in the query.

[phigga]

in this case, news would have to be the table name (at least that's what usually comes after FROM :-) )