mySQL4.1 - using DISTINCT in WHERE ?
Posted: Fri Apr 27, 2007 5:20 pm
I'm trying to retrieve all the columns in any rows that fall between a date range and have distinct emails...
The above works, but only returns the email column for each row.
How can I can all the columns for each row?
thx.
Code: Select all
sql_query("SELECT DISTINCT `email` FROM "._MY_TABLE." WHERE ts BETWEEN '$startdate' AND '$enddate'");How can I can all the columns for each row?
thx.