what does this error mean ???

[popcop]

im sending news to a database and when i go to view it on the page i get this 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 'FROM news ORDER BY thedate DESC LIMIT 6' at line 1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/m8mag/www.m8magazine.com/www/newsite/viewnews.php on line 59

can anyone explain this to me ??

[designguy79]

Your MySQL query is not the correct syntax. Could you post that?

After you run a query, it is a good idea to test to make sure it ran as expected. Try something like this:

$myquery = "SELECT id, name FROM mytable";
$result = mysql_query($myquery);
if(!$result) echo "error in query: \"".$myquery."\" -- ".mysql_error();

$array = mysql_fetch_array($result);