little problem in displaying the next row data from db..

[tru's]

i'm a beginner in php..i tried to display the record of the db in php. i create the variable to see the next record by $q=row+1 to display the next record of same country.. but it didn't appear. it recurr the first record...i don't know the problem, can help me ...

[R0bb0b]

There are several ways, here are just a few:

mysql_fetch_assoc:
http://us.php.net/manual/en/function.mysql-fetch-assoc.php
mysql_result:
http://us.php.net/manual/en/function.mysql-result.php
mysql_fetch_array:
http://us.php.net/manual/en/function.mysql-fetch-array.php

[MVied]

i'm a beginner in php..i tried to display the record of the db in php. i create the variable to see the next record by $q=row+1 to display the next record of same country.. but it didn't appear. it recurr the first record...i don't know the problem, can help me ...

You're going to have to elaborate a little bit more for me to throw any suggestions your way. From what I've read, you're trying to display a list of countries from a database?

[Shanti C]

you can retrieve database information like this:

while($r=mysql_fetch_assoc(mysql_query("select * from your table")))
{
echo $r['yourfield'];
}