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