RE: [PHP] limit 1
| From: | (Dave) | Date: | Fri, 24 Aug 2001 22:04:16 +0000 |
| Subject: | RE: [PHP] limit 1 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-64342@lists.php.net to get a copy of this message | ||
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:jeremy@prepresshelp.com]
>
>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?
>