Re: Arrays - I may have gone blind
| From: | Seraphim | Date: | Mon, 16 Dec 2002 14:06:33 +0000 |
| Subject: | Re: Arrays - I may have gone blind | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-17419@lists.php.net to get a copy of this message | ||
> Or can a SQL statement do this in a DISTINCT like way? (SELECT
> table.id FROM table WHERE somthing is = somthing else and a lot of
> other stuff BUT only give me those where table.type has the hifgrst
> value)?
>
> Please... need help with this
> ~ Aidal.
SELECT t1.id
FROM TABLENAME t1
WHERE t1.type = ( MAX (SELECT t2.type
FROM TABLENAME t2
WHERE t2,id = t1.id ) )
I think this would do what you want.
I'm also new at this and have never used this before, so it's likely to
contain some errors but if you do a google search you should be able to fish
those out.
good luck,
-Peter