Member Avatar for nationwide13

okay, so im decently new to php, but im learning, and i've hit a small block. i'm creating a table to display points per game, but i dont have a column in my database for average points, i have points and games played, so the table is getting the value of 'points/games'. the mysql query gets the values by order of points descending, however when doing averages, the person with the most points doesnt necessarily have the most points per game, so my sort goes all out of wack, but im not sure how to change the sort. any ideas?

thanks in advance
-Alex

  • 2 Contributors
  • 1 Reply
  • 62 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol

SELECT ... POINTS/GAMES AS ave ORDER BY ave

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.