Help with MySQL query

[fearmyride]

[code]mysql_free_result($result);
$query = "SELECT * FROM video_comments WHERE vid_id = $vid ORDER BY date DESC";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

    echo "<span class=\"embed\">{$row[2]}<span class=\"embed-caption\">{$row[4]}</span>{$row[3]}<br />&nbsp;<br />";
     
}
[/code]

gives me this warning: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ....../video.php on line 80


What i'm trying to do is get the comments for each item and display them ordered by date, if there is another way please let me know,


thanks so much

[ober]

That means there is something wrong with the query.

try this:
$result = mysql_query($query) or die ("error: " . mysql_error());

[fearmyride]

I did that and i got this error:
error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY date DESC' at line 1