mysql_num_rows&fetch_array not working

[Anon]

I'm using 2 mysql/php fuctions that are causing errors in my script, here is a block of the script that calls an error:

$query="select * from fiction";

$result=mysql_query($query);

$num=mysql_num_rows($result);

$row=mysql_fetch_array($result);

echo "<center>Stories Submitted:".$num."</center>";

echo "<a href='f.php?id=read&title=".$row["title"]."'>".$row["title"]."</a>-".$row["average"]."<br>
By <a href='f.php?id=profile&username=".$row["username"]."'>".$row["username"]."</a><br>
<br>";

I get the error:Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site43/web/f.php on line ***

[tomhath]

The invalid result is coming from mysql_query. Either you aren't connected to the database, or the SELECT failed for some other reason (missing table, etc).