Warning help needed - clueless

Hello
I have been moderating a phpweblog website (www.sfdrcm.com) but am clueless
about the programming.
In the last few days the following warning had appeared before each news
article

Warning: mysql_result(): supplied argument is not a valid MySQL result
resource in /home/sfdrcm/www/include/common.inc.php on line 94

The code block that contains line 94 is this:

function F_topicsel($topic="1") {
global $db;
$sql = "SELECT * FROM T_Topics";
$result = mysql_query($sql,$db);
$nrows = mysql_num_rows($result);
$tmp = "";
for ($i=0;$i<$nrows;$i++) {
$A = mysql_fetch_array($result);
$foo = $A["Topic"];
$ass = ($A["Rid"]==$topic ? "selected" : "");
$tmp .= sprintf("<option\tvalue\t= \"%s\" %s>%s</option>\n",
$A["Rid"],$ass,$foo);
}
return $tmp;

I'm not a programmer. What do I need to do to stop this error message?
Thanks






;

Earle wrote:
> Hello
> I have been moderating a phpweblog website (www.sfdrcm.com) but am
> clueless about the programming.
> In the last few days the following warning had appeared before each news
> article
>
> Warning: mysql_result(): supplied argument is not a valid MySQL result
> resource in /home/sfdrcm/www/include/common.inc.php on line 94

This indicates that the SQL question failed, as if the table T_Topics
has changed name or that the privileges has been changed for the user
you are connected in the php script.


> The code block that contains line 94 is this:
>
> function F_topicsel($topic="1") {
> global $db;
> $sql = "SELECT * FROM T_Topics";
> $result = mysql_query($sql,$db);
> $nrows = mysql_num_rows($result);
> $tmp = "";
> for ($i=0;$i<$nrows;$i++) {
> $A = mysql_fetch_array($result);
> $foo = $A["Topic"];
> $ass = ($A["Rid"]==$topic ? "selected" : "");
> $tmp .= sprintf("<option\tvalue\t= \"%s\" %s>%s</option>\n",
> $A["Rid"],$ass,$foo);
> }
> return $tmp;
>}

function F_topicsel($topic="1") {
global $db;
$sql = "SELECT * FROM T_Topics";
$result = mysql_query($sql,$db);
if(!$result) { return; }
$nrows = mysql_num_rows($result);
$tmp = "";
for ($i=0;$i<$nrows;$i++) {
$A = mysql_fetch_array($result);
$foo = $A["Topic"];
$ass = ($A["Rid"]==$topic ? "selected" : "");
$tmp .= sprintf("<option\tvalue\t= \"%s\" %s>%s</option>\n",
$A["Rid"],$ass,$foo);
}
return $tmp;
}


--

//Aho