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, at 8:19

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, username from

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: [PHP-DB] DISTINCT and multiple results...

2004-06-07 Thread Tyler Replogle
first_name: $first_name br 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 how can I select other info from the same table (title, first name