Error with mysql_fetch_array();

[haavarm]

Hi!

I get this error, what can I do to fix it?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\xampp\htdocs\funksjoner.php on line 1239

And the code:

function visKommentarer ($oppgave_id) {
	$query = "SELECT *,DATE_FORMAT(date,'%b %e, %Y - %r')\"formatted_date\" FROM kommentarer WHERE oppgave_id='$oppgave_id' ORDER BY dato ASC";
	$result = mysql_query($query);
	?>
	<table cellspacing=1 cellpadding=4 border=0 bordercolor=000000 align=center width=90%>
	<tr valign=top>
		<td width=20% class=header align=left>
		<b>Kommentarer</b>		</td>
		<td width=80% class=header align=right>
		<a class=headerlink href=<?php echo $_SERVER[PHP_SELF]; ?>?prosjektweb=leggtilkommentar&oppgave_id=<?php echo $oppgave_id; ?>>LEGG TIL KOMMENTAR</a>		</td>
	</tr>
	<?php
	while ($current = mysql_fetch_array($result))  {

	if (brukerFinnes($current[bruker_id])) {
		$navn = faaBrukerVal($current[bruker_id], LISTEVISNING);
	} else {
		$navn = "Slettet bruker";
	}
	$formatted_comments = stripslashes(nl2br($current[kommentar]));
	?>
	<tr valign=top>
		<td class=darker align=center><b><?php echo $navn; ?></b><br>
		<?php echo $current[formatted_date]; ?><br>
		<a href=<?php echo $_SERVER[PHP_SELF]; ?>?prosjektweb=endrekommentar&kommentar_id=<?=$current[kommentar_id]?>><img src=img/e-on.png border=0></a> 
		<a href=<?php echo $_SERVER[PHP_SELF]; ?>?prosjektweb=slettkommentar&kommentar_id=<?=$current[kommentar_id]?>><img src=img/d-on.png border=0></a>		  </td>
		<td class=lighter>
		<?php echo $formatted_comments; ?>			</td>
	</tr>
	<?php
}
?>
</table>
<?php
}

And the code on the line 1239:

while ($current = mysql_fetch_array($result))  

Please help me

[laserlight]

Check:
1. The database server connection.
2. That a valid database was selected.
3. That the SQL statement is correct.

[haavarm]

I have checked the database and connection...its not wront.

[Houdini]

Try echoing this

$query = "SELECT *,DATE_FORMAT(date,'%b %e, %Y - %r')\"formatted_date\" FROM kommentarer WHERE oppgave_id='$oppgave_id' ORDER BY dato ASC";

and you might find hte problem.