mysql_fetch_row, not valid mysql resource??

Darkbolt

Hi, this problem Im having is part of a news script , this particular part lists the current news items and formats it into links so it can be edited.

The error I get is
Warning: Supplied argument is not a valid MySQL result resource in /var/www/news/edit.php on line 41

(line 41 is line 2 in this php quote)

			$query = mysql_query("SELECT * FROM news ORDER BY id desc");			
			while ($result = mysql_fetch_row($query))
			{
				echo "
					<tr>
						<td>
							$result[1];
						</td>
						<td>
							<a href=\"edit.php?action=edit&id=$result[0]>$result[2]</a>
						</td>
						<td>
							$result[8]
						</td>
						<td>
							$result[3]
						</td>
					</tr>";
			}
			echo "</table>";

I cant think of what could be causing this problem...it all looks ok to me...any help would be appreciated, tia :rolleyes:

jpmoriarty

more than likely there are no rows to fetch - ie the table is empty (or at least your query isn't returning any data)

laserlight

If there are no rows to fetch, the loop should just exit immediately.

You should check that the script has a connection to the database and a database is selected.
Other cases where this occurs is when the query is malformed, but in your case it looks ok, unless the names are wrong.

One way to check:

$query = mysql_query("SELECT * FROM news ORDER BY id DESC")
	OR die(mysql_error()); //for debugging
while ($result = mysql_fetch_row($query))
{
	//output
}