Prompt message at the time when deadline comes

[khushhappy]

Dear All,
i want to make a program through which, our chairman gets a prompt message one day before a deadline of a specific event comes.
In database, il make a database fields like,
serialno, file, intial date, deadline date, status

how a user to get a deadline prompt message continues blinking when a deadline of a file comes?
Help Please !

[Bachu]

Compare Today date and Dead line date...
If Today date is less than deadline date , Print your Prompt

message in blinking area..

If you have any doubt in date and date comparison, please check

http://php.net/manual/en/function.date.php

http://www.highlystructured.com/comparing_dates_php.html

[diafol]

How is your date data stored? unix datetime (2013-01-02) or unix timestamp (1357084800).

[khushhappy]

Hi,
Diafol,
Im storing date in YYYY-MM-DD format for eg 2013-12-30

[khushhappy]

Actually i want to alert the user the number of timeout events with a alert message with an option for VIEW those timeout events OR CLOSE.

[diafol]

If you want js alert:

var diff = new Date(new Date("2012-01-03") - new Date("2012-01-02"));
alert(days = diff/86400000);

You can insert dates from php:

var diff = new Date(new Date("<?php echo $date1;?>") - new Date("<?php echo $date2;?>"));
alert(days = diff/86400000);

[khushhappy]

No, Diafol;
your not getting the point !
I dont want user to input into prompt message.
i want to show an alert message on the basis of the recordset showing records of pending events which have crossed the deadline dates.

need:-
1) alert box showing options
i)VIEW
ii) CLOSE

what i need is a alert box ! havivng option VIEW and CLOSE, If user clicks VIEW it redirects to the page showing the timeout/pending records else on the same page..

[khushhappy]

KINLDY SEE THE ATTACH JPEG IMAGE.

[diafol]

OK, use the datediff function in mysql.

SELECT * FROM table WHERE DATEDIFF(`deadline_date`,CURDATE()) <= 1

You can then get the actual items and the total number of them.
Or if you just need the total number for showing in the alert box:

SELECT COUNT(*) AS cnt FROM table WHERE DATEDIFF(`deadline_date`,CURDATE()) <= 1

Warning: Not Tested