NukeCoder

Posted: Tue Jan 02, 2007 2:06 am

I am entering peoples birthday into the db through simple select boxes.

Then mktime etc etc.

This is the odd thing. Anything before 12/31/69 will not enter. Any idea's?

Code:

echo "<select name='birthyear'>";
echo "<option value=\"\">--------</option>";
$i = date("Y")-99;
$y = date("Y");
while ($i <= $y) {
$k = $i * 1;
echo "<option value='$k'>$k</option>\n";
$i++;
}
echo "</select>";

Posted: Tue Jan 02, 2007 2:11 am

o and the column its going into is varchar(255) NULL

Site Admin Joined: Oct 25, 2004 Posts: 921

Yeah, there are some problems with storing birthdays in a timestamp, basically the timestamps start at 12/31/69 which is 0

I would suggest storing it as an actual m-d-y or even break the m,d,y into separate fields to make sorting easier...

The best option would be to use the Pear Date Class.
It might be a pain to figure out how to use it, but in the end it could help quite a bit.

Posted: Tue Jan 02, 2007 2:53 am

As it is a package getting ready for distrobution which already requires GD and possibly zend optimizer(possibly). I am gonna try to go with m-d-Y. It will be a lot easier to manipulate into my birthday function as is.

http://www.t3gamingcommunity.com/modules.php?name=Clan_Roster

Thanks on the timestamp though, I was unaware of that.

Posted: Tue Jan 02, 2007 3:10 am

ack, the problem with that is then formatting the date out from the db. Crying or Very sad

Posted: Tue Jan 02, 2007 3:45 am

Ok got this worked out with some figgling. What ended up working the best for now is 3 seperate columns.

Thanks gotcha