Home N-13 News Forums Help Search
RegisterForgot password?
How to add image to post necklacesdiscou
Known bugs - 4.0.3 necklacesdiscou

Latest N-13 News 4.0.3

What is N-13 News?
Where can I get help?
Known bugs

Forums Help & Support Warning message when using $CAT="all"
Tegwin
Posted on 07 Aug 2008, 08:53:46

Access: Member
Total Posts: 8
Joined: 2008-08-07

Hi. awsome web app!!

When I select a specific catagory
Quote:
($cat="shoes")
I get all the news for that gatagory..

But..

If I put
Quote:
$cat="all"
I get ALL the news as well as this warning message..

Quote:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\mydomain\news_engine\index.php on line 337

I would really appreciate it if someone could tell me why.

Chears.
#309
Last edited by Tegwin at 2008-08-07 08:54:20 Reason:
Chris
Posted on 07 Aug 2008, 11:13:26

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Hi Tegwin,

This was actually an error that was recently discovered by another user, to fix it simply edit the index.php, on line 325~ you'll see

Code:
$sql = "SELECT * FROM `$newstable` AND approved = '1'";

simply change that to

Code:
$sql = "SELECT * FROM `$newstable` WHERE approved = '1'";

save and upload and this should fix the problem.
#310
Tegwin
Posted on 07 Aug 2008, 11:23:11

Access: Member
Total Posts: 8
Joined: 2008-08-07

You sir are a legend! Thankyou for that, problem solved
[img]http://www.sambourne.wilts.sch.uk/images/thumbs_up.gif[/img]
#311
Network-13.com © 2013