Jump to content

Help with MySQL query


fearmyride

Recommended Posts

[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
Link to comment
https://forums.phpfreaks.com/topic/32884-help-with-mysql-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.