Jump to content

truCido

Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

truCido's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I want to display Planet in one column, score in another and then rank in another as well, its not the html that I can't do its the presenting the results from the query
  2. Basically I know how to create the query in SQL to output the result I want however I'm having problems outputting this onto a PHP page? Basically all I want to do is to put a rank along side each result. [code]SELECT a1.planet, a1.score, COUNT( a2.score ) as rank FROM pa_planet_listing a1, pa_planet_listing a2 WHERE a1.score <= a2.score OR ( a1.score = a2.score AND a1.planet = a2.planet ) GROUP BY a1.planet, a1.score ORDER BY a1.score DESC , a1.planet DESC ;[/code]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.