...

View Full Version : to do list



Lyconpire
03-26-2007, 03:18 PM
Hi,

Am making a web based to do list in order to keep myself organised and see stats of what I have done and need doing at the end of the week. Am also doing this to learn more on how php and mysql can work together.

I have done almost everything apart from the stats at the end of each week. As am unsure on how to get php to count how many jobs need doing and also count how many have been marked as done. I then need this to be refreshed each week but some how have the old stats logged away some where.

Thanks

maghiel
03-26-2007, 03:48 PM
where are you storing your information?

rafiki
03-26-2007, 06:14 PM
Am also doing this to learn more on how php and mysql can work together.

Im guessing at MYSQL database, just dont delete it from table, add a field called something like..
done then change it to true when its done, then to see all the jobs you have done

SELECT * FROM 'todo' WHERE 'done' = 'true'
or similar
im not too good with php but seems thats how it could be done

Inigoesdr
03-26-2007, 07:56 PM
You could also store the count in a table and just update it once a week.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum