I took database course two years ago and I am having a serious problem.
I created a table called pet with mySQL 5.0 and it has 6 fields. Among them are two fields for birth Date and death Date.
When inserting the data I have one pet born today. I am trying to query the pet who was born today but it is not working. Here is my syntex
Expand|Select|Wrap|Line Numbers
- SELECT *
- FROM pet
- WHERE birth Date = CURRENT_DATE( ) ;
WHAT AM I DOING?
If this query works. I want to create a TABLE month with date field and message field. Then query it in such a way that each day the message automatically be displayed on our web site as a daily devotional. I do not know if it will work or not.
If there is anybody out there who can help me with the query above and may be another alternative of my goal please helo me.
Thanks
kyan