[SOLVED] UNIQE ARRAY

[crashmaster]

Hi there,

I have one problem/

 

ex. of mysql database 'test'

-----------------

id: 1 , name:Admin

id: 2 , name: user1

id: 3 , name: Admin

id: 4 , name: user2

id: 5 , name: user1

-----------------

 

ex. of the mysql_qery

$query = mysql_query("SELECT name FROM test");

 

What I need:

I need to create array $names, where each 'name' will be only once.

 

I've tried this, but it doesnt work

while ( $z = array_unique(mysql_fetch_array($query)) ) { 
echo $z[name];
}

 

I need to have output like this:

$names = array ('Admin', 'user1', 'user2');

 

 

Can somebody help me...

 

 

[rajivgonsalves]

you should fetch the array fetch and then try a array_unique you may have multiple records

[crashmaster]

can you write me example of the code ? Thanks

[wsantos]

Why not do it from the query itself? It seems you are just getting the name column

 

$query = mysql_query("SELECT DISTINCT name FROM test");

 

That should get the unique data

[toplay]

Just use the DISTINCT keyword in your query.

 

$query = mysql_query("SELECT DISTINCT name FROM test");

 

 

http://dev.mysql.com/doc/refman/5.0/en/select.html

 

EDIT:

 

wsantos beat me to it.