Hi! Your N-13 News 3.1 is a great app.I love it very much, but i'm receiving an error message.
i'm using the following codes on my existing page.
Code:
<?php
$cat = "all";
include 'article/index.php';
?>
The news are showing up correctly I suppose..but i got this warning message
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/easyhome/public_html/article/index.php on line 337
code at line 337 was
Code:
$totalnews = mysql_num_rows($query);
I replaced it with
Code:
$totalnews = mysql_num_rows($query)
or die("Query error: ". mysql_error());
and here is what i got
Code:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/easyhome/public_html/article/index.php on line 337
Query 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 'AND approved = '1'' at line 1
please tell me how to fix it
thank you
//my server infos
Apache ver 2.2.8 (Unix)
MySQL ver 4.1.22-standard-log
PHP ver 5.2.6
Latest