hi friends,
when the event is retrieving the records from the table based on ( date and time).when the event checks the records it first check the reqdate and time should be below 1 hour to the current date and time.If this condition matches the record then it display.
Here my problem is that when it is checking after 3 minutes it displays the same record which was previously displayed
i don't want to display the same record even the event running again and again.
Please tell me the condition, such that when it display the record then it should not display the same record again.but the event should check the table on every 3 minutes.
CREATE EVENT `zeeevent` ON SCHEDULE EVERY 3 MINUTE
DO
insert into zeetemp(booking_id,contact_name,vehicle,pickup_addr,drop_addr,reqdate,time)
select booking_id,contact_name,vehicle,pickup_addr,drop_addr,reqdate,time from booking_details
WHERE reqdate + INTERVAL TIME_TO_SEC(time) SECOND
BETWEEN CURRENT_TIMESTAMP AND CURRENT_TIMESTAMP + INTERVAL 1 HOUR
Thanks in advance
Display the records only one time
Moderator: General Moderators
Re: Display the records only one time
Just add a read column to the table. Once it was read mark it read ... you could use a date or just an enum or boolean
Re: Display the records only one time
how to delete the record manually, once i get the record from the database 