[Resolved] Not selecting duplicates

Hello.

I am using mySQL.

I have a select statement which after the mysql_query(), i use mysql_num_rows() to find out how many items there are.

I need to ignore duplicates (of an email address). So 5 fields, where 4 emails are the same would return 2 (unique email and 1 of the duplicates).

Ideally i would just have something to add onto my current query:

$sql="SELECT * FROM table WHERE (some date stuff) AND (no duplicates)

Is this possible? - if so how?

Thanks!

select DISTINCT email from table where ...

Thanks!