Jump to content


Photo

How to use DISTINCT with dreamweaver mysql


  • Please log in to reply
No replies to this topic

#1 khan kaka

khan kaka
  • Members
  • PipPipPip
  • Advanced Member
  • 40 posts
  • Locationaustralia

Posted 31 January 2006 - 02:43 AM


i have a table wiht name field and address field.

i have alot of duplicte names but diffrent address. how can i list only one name.

i used SELECT DISTINCT (links.name), links.info
FROM links

but it still returns all names.



khan kaka




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users