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
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]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
This may only be preference but you've mixe
This may only be preference but you've mixed join syntaxes here, it would be easier to
read if you stuck with just one.
Anyway, I think what you'll want is to max the whole expression. So, keep the group
by, but use
max (if(u.country='gm',25,0) +
if(u.age='4',25,0) +
if(u.sex='2',2