You have not given enough information to allow anyone to help. Please explain in detail where the mysql date is stored and what you want to check it against.
date is stored in mysql table in DATE format, and I need to check it using php against curent date, in conclusion should get “is it a birthday?”, and checking must check DB every day and notice about birthdays.
Still not enough detail.
Is the table in the WP database, or a different DB?
Is the table a standard WP table, or not?
You want to check the table every day. Do you have visitors to your site every day?
Assuming the table is in the WP database, but not a standard WP table, you can use the code in this article as examples of how to access the database:
http://wordpress.mcdspot.com/2010/03/15/code-to-dropcreateaccess-mysql-table/
If you have visitors to your site every day, you can use one of the WordPress Cron Job plugins to set up a job to run the first time someone visits your site each day.
If you do not have visitors every day, you must us a server cron job to run the check. Setting that up is beyond the scope of this forum.
If all of this is confusing to you, you may need to hire someone to do the work. You can post a free job request on jobs.wordpress.net.
Yes its in WPDB and whit wp_ prefix but custom table.
Yes, I want to check every day. This will be new site so I dont have info about visitors.
can you advise mysql and php functions to help me?
The article I referenced above has sample php and mysql code.
The plugins I referenced have installation and usage instructions.
