TalkPHP - View Single Post - How to get row number from 2 top numberd rows

Wildhoney · 01-27-2009, 10:42 PM

Hmm. I think the query I posted to you originally will do it for you. Try something like the following in your PHP code, after the query:

php Code:

while ($row = mysql_fetch_array($sql))
{
    printf("The country %s has %d entries",
    $row['country'], $row['num_entries']);  
}

Is this what you're after? It will display how many rows there are of that particular country, ordered with the most popular at the top.

01-27-2009, 10:42 PM	#5 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	Hmm. I think the query I posted to you originally will do it for you. Try something like the following in your PHP code, after the query: php Code: while ($row = mysql_fetch_array($sql)) { printf("The country %s has %d entries", $row['country'], $row['num_entries']); } Is this what you're after? It will display how many rows there are of that particular country, ordered with the most popular at the top. __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.