Charting only the highest 10 values of a field?

[Tombstone]

Hi all,

 

 

 

Probably a stupid question, and may well just be me being dumb, but assuming I have a field (Pages) within my database, is there anyway to chart only the 10 records with the highest number of Pages?

 

 

 

I can successfully chart everyone of course, but its mayhem on a piechart with 400 records showing

[Dhruva]

Hello Tombstone,

Welcome to the forum

Could you please try to pass an SQL Query which will return the top 10 rows of the table (on the basis of your chosen field) to the FusionCharts class?

[Tombstone]

Dhruva (4/1/2009)

---

Hello Tombstone,

 

 

 

Welcome to the forum

 

 

 

Could you please try to pass an SQL Query which will return the top 10 rows of the table (on the basis of your chosen field) to the FusionCharts class?

 

 

 

Thanks,

 

 

 

I think I am way off the mark on this, been staring at too much PHP today and its all blending into each other

 

 

 

Just operating off the dbexample.php at the moment, and tried this..

 

 

 

$strQuery = "select * from (SELECT Pages FROM April ORDER BY Pages+0 DESC) as TotOutput where ROWNUM < 11 and User=" . $ors['User'];

 

 

 

But that seems to be totally wrong, which isnt surprising for me

[Dhruva]

Hello again!

Could you modify your query thus, and try again?

$strQuery = "select * from (SELECT Pages FROM April ORDER BY Pages+0 DESC LIMIT 10) as TotOutput where User=" . $ors['User'];

Hope this helps!

[Tombstone]

Thanks

 

 

 

Luckily I managed to get it sorted this morning, amazing what a night of not staring at the php can do

 

 

 

Corrected the error I was making and its now working beautifully !

[Dhruva]

Hi!

You're welcome!

Understandably so. :hehe: Looking constantly at code can make one woozy. We're people, after all, not compilers.

Always happy to help, though!