selecting rows that are not expired

[jakebur01]

I have two seperate expiration dates. ( Date_expired and Expiration ) I want to select only the rows that are not expired and have not hit either one of these dates.

 

Here is my query:

 $result = mysql_query("SELECT * FROM dog_listing WHERE `Breed` = '$breed' ORDER BY Date_created ASC ", $db) or die(mysql_error());

 

How could I add Date_expired and Expiration into my query to where I am selecting only the rows that are not expired?

[Barand]

WHERE breed = '$breed'

AND CURDATE() < date_expired

AND CURDATE() < expiration

[jakebur01]

cool thanks.