"Echo" data from a database table depending on the date

Hello! I’m a novice programmer attempting to display a “daily health tip” for my company’s intranet, wanting it to change daily and I’ve been looking around trying to figure out the “where” function. In the database, I’ve got the “id” column setup with the date and then the “text” column with the daily health tip. I have been trying to get the “where” function to act with the current date to get it to switch. I’ve gone through several other websites attempting to figure this out to no avail. Any assistance with this would be fantastic! Thanks!

Also, if it isn’t clear by the post, I’m using PHP/MySQL. Thanks!

Welcome to the SP forums.

Please post the table definition and the query you’ve got so far.

Would that be a different health tip for each day of the year then?