• Quick links
    • Unanswered topics
    • Active topics
    • Search
    • The team
  • FAQ
  • Login
  • Register

PHP forum, your PHP coding community

A community in which webmasters can ask for help with topics such as PHP coding , MySQL , IT jobs, web design, IT security.

  • Home Board index php forum :: Database mySQL & php coding
  • Search

High score position

Codes here !

Moderators: egami, macek, gesf

Post Reply
  • Print view
Advanced search
1 post • Page 1 of 1
DoppyNL

  • Quote

Fri Nov 01, 2002 6:10 am

Once you know the score of the entry you can determine its "rank" by selecting all records wich have a better score.
The number of records that comply with that query are in front of that score.

example:
rank..score
1..10
2..8
3..5
3..5
3..5
6..3
7..2
7..2

When you want to know the position of score "5", you find out that there are 2 records in front of that, 2 + 1 = 3 -> position 3.

I think you can build the query yourself.

Greetz Daan
Top

Post Reply
  • Print view
1 post • Page 1 of 1

Return to “mySQL & php coding”

Jump to
  • php forum :: php coding
  • ↳   PHP coding => General
  • ↳   PHP coding => Images
  • ↳   PHP coding => Mail
  • PHP
  • ↳   PHP General
  • ↳   PHP Scripts
  • ↳   PHP Installation
  • ↳   PHP Jobs
  • ↳   PEAR and PECL
  • ↳   Your Scripts
  • php forum :: Database
  • ↳   mySQL & php coding
  • ↳   phpMyAdmin
  • ↳   MySQL Installation
  • ↳   Other Database Engines
  • php forum :: PHP and MySQL Security
  • ↳   PHP & MySQL Security
  • System Administration
  • ↳   Server installation and configuration
  • ↳   Server security
  • php forum :: HTML
  • ↳   JavaScript
  • ↳   HTML Basics
  • ↳   CSS
  • php forum :: Bar
  • ↳   Free time
  • ↳   News and Announcements

Login  •  Register



ADVERTISEMENT


ADVERTISEMENT


ADVERTISEMENT

  • Home Board index
  • All times are UTC-08:00
  • Delete all board cookies
  • The team
  • Contact us
 

 

Powered by phpBB™ • Design by PlanetStyles
cron