I simply need a number

ligraci

Hi to all!
I have a little proble with my php code.

This is my code:
$result = mysql_query("SELECT name,point from tablename where points >= $points ORDER BY points ASC limit 7",$db);

and this is a possible result:
NAME | POINTS
Mark | 100000
David | 90000
Me | 74000
...

Note that David is the second in the list, he is number 2. I need to get the number 2. How can I do? Which function have I to use to solve my problem?

Thanks a lot for your help.
Danielli

brandonschnell

either loop through the array getting the 2nd row (mysql_fetch_array), or rewrite the query to only get the 2nd row:

$result = mysql_query("SELECT name,point from tablename where points >= $points ORDER BY points ASC limit 1,1",$db);

ligraci

Thanks for your help!
Maybe I didn't explained well my problem. I don't know the number of the row that I'm looking for because I need to get it using a function after the query. The only thing that I know is the value of $points. In my example there were only 3 records but I could have thousand of records in my result. How can I get the number of the row of a particular record?

Thanks :-)

Anon

I'd suggest simply adding a field to that table with an id number, and just retrieving the id number instead of the row number

ligraci

this is what's happened with the ID number because I ordered the records by POINTS DESC:

ID | NAME | POINTS
4 |name1 | 10000
3 |name2 | 9000
5 |name3 | 8000
...

Thanks for your help, but I'm still in trouble :-)

[deleted]

So what you want is a number that is "1" for the first result of your query, "2" for the second and "3" for the third?

Why don't you just us a PHP variable and count the results as you go?

$result=mysql_query();
$counter=1;
while ($row=mysql_fetch_row)
{
echo $counter;
#print the rest ofthe row

#increase the counter with 1
$counter++
}

ligraci

Thanks for help!

I tried but this is the answer:
Parse error: parse error in myfile.php on line 24.
This is the text of line 24 :
}

:-(

I really don't know what to do to get that number.

Anon

Simply add a ; to the end of the $counter++ line and it should work.