mysql error

[Jacbey]

hey guys;

 

Another problem with sql.

 

 			{
echo "Welcome " . $row['username'];
echo "<br />";
echo "<br />";
echo "<br />";



$msgquery = "SELECT * FROM spotty_messages WHERE (id_receiver = '" . $userid . "') AND message_read = '0'";

$messageres = mysql_query($msgquery);

$messrow = mysql_fetch_array($messageres);

$messagenum = mysql_num_rows($messageres);



	}


$i = 0;
while ($i < $messagenum) {



$f1 = "From:" . mysql_result($messrow,$i,"sender");


echo "
<tr>
<td>" .  $f1 ."</font></td>
" ;
$i++;
}

 

This is returning the error : Warning: mysql_result() expects parameter 1 to be resource, null given in /customers/klueless.net/klueless.net/httpd.www/daisysite/messages.php on line 106

 

Please help, thanks!

[wildteen88]

You're using the wrong variable here

$f1 = "From:" . mysql_result($messrow,$i,"sender");

You want to use the $messageres variable (this is the result resource)

[Jacbey]

You're using the wrong variable here

$f1 = "From:" . mysql_result($messrow,$i,"sender");

You want to use the $messageres variable (this is the result resource)

 

Whoo Thanks dude; I owe you one!