php.lv forumi: Uzzināt ieraksta vietu topā - php.lv forumi

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Uzzināt ieraksta vietu topā

#1 User is offline   ziemelis Icon

  • Māceklis
  • Pip
  • Group: Reģistrētie lietotāji
  • Posts: 18
  • Joined: 2009.02.27

Posted 2010.02.03 18:48

Sveiki, sekojošs kods veido topu:
SELECT TOP 100 id, vards, punkti FROM table1 ORDER BY punkti DESC

kā lai apskatot noteiktu ierakstu, nosaka viņa vietu topā?

#2 User is offline   bubu Icon

  • Koda dievs
  • PipPipPipPipPip
  • Group: Administratori
  • Posts: 9,094
  • Joined: 2004.03.16

Posted 2010.02.03 18:57 

SELECT COUNT(*)+1 FROM table1 WHERE table1.punkti > $punkti

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic