Bir MySQL sorgusu kullanarak bir dizi elemanı için belirli bir değer atayın

0 Cevap php

Fikir gibi sıralama MySQL komut bir tür çalıştırmak için:

$sql = mysql_query("SELECT f_score FROM ".TBL_FACTIONS." ASC");

EDIT: Ben de burada bir WHERE F_ID = $ id eklemeniz gerekiyor.

The numeric value in my MySQL database table in the *f_score* column should determine the rank. f_score contains only numeric values, from 0 to anything, user actions add and subtract from the score.

then use the $sql to loop through an array and "rank" each array element. I think it should assign a number to a specific variable so I can echo the number out on the webpage.

Örneğin Your rank is: 01

I'm looking for something lightweight, but if its not possible to do this win minimum server usages, I'll have to shove it into a cron job or something which isn't really ideal. I was thinking along the lines of array and loops or something similar?

Herhangi bir yardım büyük mutluluk duyacağız!

-Callum

0 Cevap