Re: [PHP-DB] DISTINCT and multiple results...

2004-06-07 Thread Tyler Replogle
hey, you could do something like this first_name: $first_name company: $company"; } ?> From: [EMAIL PROTECTED] To: Jonathan Haddad <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] DISTINCT and multiple results... Date: Mon, 7 Jun 2004 14:05:41 +0100 Ah, but then ho

Re: [PHP-DB] DISTINCT and multiple results...

2004-06-07 Thread Torsten Roehr
"Tristan Pretty" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] com... > Ah, but then how can I select other info from the same table (title, first > name, company etc...) Just add all the required fields to your select statement: SELECT DISTINCT email, title, company FROM table Re

Re: [PHP-DB] DISTINCT and multiple results...

2004-06-07 Thread Tristan . Pretty
Ah, but then how can I select other info from the same table (title, first name, company etc...) Jonathan Haddad <[EMAIL PROTECTED]> 07/06/2004 13:39 To [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject Re: [PHP-DB] DISTINCT and multiple results... select distinct email, usernam

Re: [PHP-DB] DISTINCT and multiple results...

2004-06-07 Thread Tristan . Pretty
It really is that simple?!?!?! Wow... I need to do a MySQL course... Jonathan Haddad <[EMAIL PROTECTED]> 07/06/2004 13:39 To [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject Re: [PHP-DB] DISTINCT and multiple results... select distinct email, username from table On Jun 7, 2004, a