[need Big Help]returning User's Rank - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Error403 · 07-11-2008, 07:59 PM

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...