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 should.
>
>$sql = "SELECT users.names
> FROM users, selection
> Where users.name = selection.name and setting = 'on' limit 1
> ";
>
>What I would like to do is put a limit of 1 to only this part -----> setting
>= 'on' limit 1 <--------------- and not on the rest.
>
>You see, there are many users.name that have a setting = 'on'............I
>want, ALL those names , ONLY once..
>
>How do I do this?
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
