Can someone help me?
I Have a table that has 3 field: id, user , point
Tabel
Code:
CREATE TABLE `practice`.`member` (
`id` INT NOT NULL AUTO_INCREMENT ,
`user` VARCHAR( 10 ) NOT NULL ,
`point` INT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM
Data
Code:
INSERT INTO member VALUES
(1,'Tono',1467),
(2,'Ujang',1232),
(3,'Billy',782),
(4,'Bambang',2389),
(5,'Dino',896),
(6,'Sherly',2139),
(7,'Minah',123),
(8,'Tina',232),
(9,'Eke',1),
(10,'Momon',235),
(11,'Mimid',589),
(12,'Eenk',768),
(13,'Cuka',230)
I need a query that return the user's rank based on his point (1 row result).
Example: Mimid's rank: 8
Thanks for the help....
Almost forgot, I'm using PHP to run queries on mySQL...