On Fri, 9 Jul 2004, Peter Westergaard wrote:
>
> One idea that occurs to me, and it's a tradeoff from Torsten's idea (which
> is to read the whole database, and parse out the unique rows), is to first
> execute your "SELECT DISTINCT distinct_col FROM table", and then walk
> through that, and for ea
Lars,
One idea that occurs to me, and it's a tradeoff from Torsten's idea (which
is to read the whole database, and parse out the unique rows), is to first
execute your "SELECT DISTINCT distinct_col FROM table", and then walk
through that, and for each one issue a "SELECT * FROM table WHERE
distin
>"Lars Hilsebein" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>Sorry, but it's not truly what I am searching for:
>The result is not unique.
>What I mean is: every entry in the distinct_col should only be delivered
>once.
>As it would happen when I do the query "SELECT DISTINCT dist
hole row.
Lars
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 8. Juli 2004 19:36
An: Lars Hilsebein
Cc: '[EMAIL PROTECTED]'
Betreff: Re: [PHP-DB] fetch row DISTINCT
> I'm using PHP with mySQL since a long time.
> But now I got a q
> I'm using PHP with mySQL since a long time.
> But now I got a question:
> I need to generate a SQL-Statement to fetch rows with one DISTINCT
criteria.
> To make things clear: I don't want to fetch a single DISTINCT column, I
want
> to fetch the whole row, where one column is DISTINCT.
> Ca
I'm using PHP with mySQL since a long time.
But now I got a question:
I need to generate a SQL-Statement to fetch rows with one DISTINCT criteria.
To make things clear: I don't want to fetch a single DISTINCT column, I want
to fetch the whole row, where one column is DISTINCT.
Can someone expl