one instance of row

[azqnow]

i want to get one instance of a row...

1 usa
2 china
3 korea
4 vietnam
5 korea

for example i have these in my table and i'll retrieve it using for.. my question is how can i echo only those 1-4 in my tables or in any other case retrieve only those which are unique.. i dont want any row to repeat..

• without modifying database

i dont know what else to put in query... mysql_query("select * from trial");

[ptbsG_Man]

use

SELECT DISTINCT column_name(s)
FROM table_name

you can read about it here if you want http://www.w3schools.com/sql/sql_select.asp

Hope this works
🆒