to do lists help

[aman_batra]

hello..,

i want to make a todo list with the help of php/html. can anone guide me?

it must be a kind of that as many users can use and make their desired to dos and after that date the todo expires.

[dropfaith]

thats kinda a vague issue your going to need a form with all your inputs a php script to insert them into database then selects to get data back out and format into html

 

 

either of these Will do the delete if the date is before today

<?php
$today = date("Y-m-d");
mysql_query("delete from table WHERE date < '$today'") or die(mysql_error());
?>

<?php $today = date("Y-m-d", strtotime("-1 day"));
mysql_query("delete from table WHERE date = '$today'") or die(mysql_error());?>

 

but you need to describe what your having trouble with i cant write out the entire thing to build this and your question leaves me wondering what exactly you need help on

[aman_batra]

thanx for replying.

please guide me with the code that how to use MYSQL dates in order to insert a reminder to the date.

i'l do what you said..

i'l first make a form of req feilds and then calander will be there where a user can click and add a note on that particular date.