If statement - current date and expiry date

I have a expiry_date field in my mysql database along with some other fields…

what i want to do is write a php code that retrieves and displays only the records from the mysql database that have not expired. this is done by checking the expiry_date field of a record and looking at todays date…

someone please help me.