l have to have multiple rows per user id, one for each country.
<>< Ryan
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 4:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] stmt should return user-id only once. difficult
select statement.
ay 10, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] stmt should return user-id only once. difficult
select statement.
unfortunatelly not. I did already try this. It does not make a difference.
Still three results for each user
do you have another idea?
thanks,
Andy
"Ryan Jam
ECTED]
Subject: Re: [PHP-DB] stmt should return user-id only once. difficult
select statement.
unfortunatelly not. I did already try this. It does not make a difference.
Still three results for each user
do you have another idea?
thanks,
Andy
"Ryan Jameson" <[EMAIL PROTECTED]> s
'gm'
AND u.age = '4'
AND u.sex = '2' /* for the mandatory fields */
GROUP BY u.user_id, l.language_id
HAVING ranking > 0 /* dont return all users! */
ORDER BY ranking desc
LIMIT 0,5
-----Original Message-----
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Friday
ferent table */
AND u.country = 'gm'
AND u.age = '4'
AND u.sex = '2' /* for the mandatory fields */
GROUP BY u.user_id, l.language_id
HAVING ranking > 0 /* dont return all users! */
ORDER BY ranking desc
LIMIT 0,5
-----Original Message-
From: andy [mailto
Hi there,
I have a huge statement doing a calculation and returning a userid with a
ranking. This workes fine for one table. But due to normalisation I do have
2. table containing languages of the users. Up to 3 languages for each user.
The problem is, that I do get the same user 3 times with a