Hi all,
I need to manage some records with dates. mmddyyyy

I'm putting select options breaking the three up in numeric pull
downs. no problem gathering and storing the data in my mysql db as
integers then posting them for existing records etc. i know their is a
datetime datatype but it doesnt seem easier to use this data type than
using integers...any tips or routines for handling this?

It is much much easier to use at least the DATE type in your database.

What if, six months from now you want to select all records that occured on even numbered Tuesdays?

How would you do that if all you have is integers?

I suppose you could look at every single row and do the math in PHP, but that's going to be a pain and won't scale very well...

Good luck!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to