RE: [PHP] limit 1

2001-08-24 Thread Dave
you are probably looking for unique if not, I am not understanding what you are trying to do Dave >-Original Message- >From: Jeremy Morano [mailto:[EMAIL PROTECTED]] > >I wondering if it was possible to use limit on part of a query and not all. > >this is my query which works the way it

Re: [PHP] limit 1

2001-08-24 Thread ERISEN, Mehmet Kamil
This is a sql question: Limit is limiting number of records that will come out of query. So, it would not work. SELECT users.names FROM users, selection Where users.name = selection.name and setting = 'on' ; you could use SELECT DISTINCT users.names FROM users, selection Where users.