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 [EMAIL PROTECTED] 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:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
=
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/
--
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]