Very small mysql_fetch_assoc problem.

[Inkybro]

Okay, here's my code and what it is telling me:

<?

//Display the words: By, Subject, and Replies.
echo ("
<table>
<tr>
<td><b>By:</b></td>
<td><b>Subject:</b></td>
<td><b>Replies:</b></td>
</tr>
");

//Connect to the database.
mysql_connect("localhost","*****","*****");
mysql_select_db("wizardduels_com");

//Select all the variables from the database.
$row = mysql_fetch_assoc($forummessages);
$by = $row['by'];
$subject = $row['subject'];
$body = $row['body'];
$replies = $row['replies'];
$postid = $row['postid'];

//Display all of the variables.
echo ("<tr><td>".$by."</td><td>");
echo ("<a href=\"http://www.wizardduels.com/forums.php?user=$user&pass=$pass&post=$postid\">");
echo ("<tr><td>".$subject."</td></tr>");
echo ("</a>");
echo ("<tr><td>".$replies."</td></tr>");

?>

Here's the error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site18/fst/var/www/html/forums.php on line 18

Thanks everyone!

[rIkLuNd]

This is how I would do it:

$forummessages = mysql_query("select * from table where bla='something'");

//Select all the variables from the database.
$row = mysql_fetch_array($forummessages);
$by = $row['by'];
$subject = $row['subject'];
$body = $row['body'];
$replies = $row['replies'];
$postid = $row['postid'];

[cgraz]

As Ricklund showed, you need some kind of query to execute.

Also, If your query will return more than one row, you may want to use a while loop so that you display all the results, not just the first one.

Cgraz