Using DISTINCT

[azurian]

One of the fields in my datatbase is called County. Another is called ExpDate.

I am using SELECT DISTINCT to list the number of different counties listed in the database, but ONLY if the membership has not expired.

$now is the current timestamp. Can anyone see anything wrong with this?

$query = "SELECT DISTINCT County FROM table_name WHERE  '$now < ExpDate' ORDER BY County ASC ";

$result = mysql_query($query, $link); 
while( $row = mysql_fetch_array($result) ) {

echo("<BR>$row[County]");
}

The result appears to include counties, even when the expiry date has been passed.

[dalecosp]

Is ExpDate also a timestamp?

Also, try changing your quoting scheme, perhaps...

Finally, it's likely that pure SQL would solve this one...

SELECT DISTINCT County FROM table_name WHERE  NOW() < ExpDate ORDER BY County ASC 

See http://www.mysql.com/doc/en/Date_and_time_functions.html

HTH,

[azurian]

Thanks for your quick reply.

Yes, ExpDate also contains a timestamp.

[azurian]

Thanks dalecosp.

You were right. I had simply placed a ' in the wrong place.

Thanks for your help.