[PHP] Mysql unique statement help...

2002-04-02 Thread Dhaval Desai



Hello,

Well I have a field in Mysql Database called threadid.
I have unique threadid's stored in this field. But the
problem is that I have like 10 entries for each
threadid. When I do a select statement for Mysql I
want only unique threadid's to be read.

How do I do that because I didn't find any function as
unique() under Mysql.

Could anybody help me out please.


Thank You
Best Regards,
Dhaval Desai


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP] Mysql unique statement help...

2002-04-02 Thread RIVES Sergio

Hi,

if you want to select a unique threadid to be read, try the following
MySQL sentence :
SELECT DISTINCT threadid FROM tablename;

Hope it helps you

SR

Dhaval Desai a écrit :

 Hello,

 Well I have a field in Mysql Database called threadid.
 I have unique threadid's stored in this field. But the
 problem is that I have like 10 entries for each
 threadid. When I do a select statement for Mysql I
 want only unique threadid's to be read.

 How do I do that because I didn't find any function as
 unique() under Mysql.

 Could anybody help me out please.

 Thank You
 Best Regards,
 Dhaval Desai

 _
 MSN Photos is the easiest way to share and print your photos:
 http://photos.msn.com/support/worldwide.aspx

 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php