What's New at GPTBoycott.Com? Issue

[usdollars]

Just in case you don't already know, the "What's New at GPTBoycott.Com" page is showing last updates from June 23, 2005.

[Taff]

lol Rob must be 2 yrs behind everyone else lol

Thanks usdollars

[usdollars]

Either that or I'm 2 years ahead :hehe:

[SEO expert]

I think he forgot to change his calender from last 2 yrs....lol :laugh:

[cybertongue]

Perhaps there hasn't been anything new going on here in the last two years... ;)

[DAzHiredGun]

Perhaps there hasn't been anything new going on here in the last two years... ;)


:laugh::laugh::laugh::laugh::hehe::hehe::hehe:

[Rob]

Thanks for spotting this - how embarrassing!

I'm going to try updating the forum to the latest version to see if this helps fix the problem...

[usdollars]

Thanks Rob.

[Rob]

Well, that didn't do the trick (but at least the forum is upgraded :p)

I'll try jiggling around with a few things and keep my fingers crossed...

[SEO expert]

Don't worry Rob....hope everything will be fine after this change...:laugh:

[Rob]

I'm still extremely confused by this error... :(

[SAS-Rod]

I'm still extremely confused by this error... :(

Rob, I am guessing you have some new information that "should" be displaying, correct?

As I view the What's New section, I am viewing them in chronological order (oldest to newest).
It SHOULD be newest to oldest (that way, the older ones get dropped off the list).

That means the query that is digging up all the whats new fields in the database is sorting them from oldest to newest and your newer ones are simply beyond the first 4 that is displayed.

To remedy this, you need to find the query table that is doing this and add this at the end of the query string: ORDER BY Date DESC (where Date is whatever the Date field is in that table). Actually, there is probably a "Limit 4" in the query string as well so it should read: ORDER BY Date Desc Limit 4

At the moment, it is either showing ORDER BY Date ASC or no "ORDER BY" at all and simply pulling the first four entries into the query (my guess is the first time anyone made any entries is in 2005 by you?)

Let me know if that does the trick.

[Rob]

Thanks for that Rod... unfortunately I've tried the things which you have suggested and it still won't work properly. The fields are showing properly, but it simply won't order them in the right way!

This is especially strange since it always worked before, and then just stopped working without me editing the script at all.

Rob

[Rob]

Rod has been helping me via PM and I am delighted to say that the feature is now working again, and can be seen at http://www.gptboycott.com, our home page!

Thanks to usdollars for bringing this to my attention and to Rod for helping me to fix it.

Rob :)

[usdollars]

That's excellent news Rob and yes thanks to Rod for helping :)