mysql query questionq

[Anon]

Lets say i have a table with 2 fields: id and text;

query is:

select distinct(text) from table;

how the hell can i get if of this text row?

something like:
select distinct(text,id) from table;
but it doesn't work ofcourse

have looked over mysql manual but nothing!

thx!

artur
newside.gz.ee/wapline

[Anon]

sry!
the question is:
how the hell can i get id of this text row?

not if!

[Anon]

$result = ("select * from tablename", $db);

while ($myrow = mysql_fetch_array($result)) {
$id = $myrow["id"];
$text = $myrow["text"];
}