Member Avatar for shamsidah

hye everyone..i just want to share my problem using php..:$

i have data for field total

i.e total = (2,3,4,5,62,45,67,89,10,23,11,23,98,12)

from all data i want 5 max values only. please help me to meet the solution.:)

  • 3 Contributors
  • 4 Replies
  • 102 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by rotten69

Recommended Answers

All 4 Replies

Member Avatar for pritaeas

What are you looking for, how to do this with a query ? Can you show the code you have so far ?

Member Avatar for shamsidah

actually im looking the max value from my table (grandtotal). i just want to display 5 values from that.

Member Avatar for pritaeas

It'll probably be something like this:

SELECT total FROM grandtotal ORDER BY total DESC LIMIT 5
Member Avatar for rotten69

Did you want just the MAXimum value out of that set of numbers you provided us??

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.