How to filter result Select SQL not double?

[warik]

Dear all,

I have problem for output sql query become double, how to make it show only 1 even there are more than 1 at record table.

Maybe filter the output or something else ?

e.g.

table name=data

number | owner
11 | jon
30 | ane
14 | jack
12 | jon
40 | ken
15 | susi
55 | don

the sql :

$query = &quot;SELECT * FROM data WHERE number < 20&quot;;
$result = mysql_query($query);

if ($row = mysql_fetch_array($result))
{
do
{
echo &quot;$row[0]<br>&quot;;
} while ($row = mysql_fetch_array ($result));
}


The result will be :

jon
jack
jon
susi

There are 2 jon.

What I need just only one result if the same like this :

jon
jack
susi



Pls help me

Thank's in advance

 

[namida]

how about selecting only the name and then using DISTINCT?

like

SELECT DISTINCT name where number<20

or try using GROUP BY name ?

 

[namida]

Sorry name should be owner.. didn't catch that

Or if you insist on using the php you could create another array and transfer the name one by one, checking each value owner with the second array for same/already transferred value..

 

[warik]

Nomida, it work as what I need.

I use :

SELECT DISTINCT name FROM data WHERE number<20


Thank you very much.