Re: limit 1
| From: | ERISEN, Mehmet Kamil | Date: | Fri, 24 Aug 2001 19:41:32 +0000 |
| Subject: | Re: limit 1 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-64318@lists.php.net to get a copy of this message | ||
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.name = selection.name
and setting = 'on' ;
or
SELECT users.names
FROM users, selection
Where users.name = selection.name
and setting = 'on'
group by users.names
--- Jeremy Morano <jeremy@prepresshelp.com> wrote:
>
> Hi,
>
>
> 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'
> ";
>
>
>
>
> 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:
> php-general-unsubscribe@lists.php.net
> For additional commands, e-mail:
> php-general-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>
=====
Mehmet Erisen
http://www.erisen.com
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/