Help with birthdays

bigrollerdave

ok say my birthday is May 19, 1987
with that in mind i would be 17 turning 18 but the script is saying the person is 18 already which isnt good because i have parts of the site blocked to anyone under the age of 18 ok here is the code

$old = mysql_query("select adv_dob from members where mem_username='$uname'");
$old = mysql_fetch_array($old);
$age = date("Y-m-d") - $old['adv_dob'];

the birthday in the database looks like this

1987-05-19

so it would be the birthday - the current date should give the age right?

Weedpacket

:glare:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10286100&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10282194&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10245644&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10238851&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10237780&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10299670&highlight=birthday+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10292774&highlight=birthday+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10281807&highlight=birthday+age

bigrollerdave

Originally posted by Weedpacket

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10286100&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10282194&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10245644&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10238851&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10237780&highlight=calculate+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10299670&highlight=birthday+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10292774&highlight=birthday+age
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10281807&highlight=birthday+age [/B]

i thought you had an answer for me =/ any one can search for a thread that has "birthday+age"

mrhappiness

Originally posted by bigrollerdave
i thought you had an answer for me =/ any one can search for a thread that has "birthday+age"

He in fact posted answers.
Why are you not willing to read them?
Why are you not capable of searching for birthday and age?

bigrollerdave

Originally posted by mrhappiness
He in fact posted answers.
Why are you not willing to read them?
Why are you not capable of searching for birthday and age?

I did read them every post actually it didn't help me though i have also spent about an hour searching on this site and google for the answer and still nothing

mrhappiness

in the 6th post weedpacket posted you find a post from mysqlf showing jansky a sql statement

SELECT
  DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW()) - TO_DAYS(birthday)), '%y') >= 18 allowed

gives you a new column called "allowed" which contains either 0 (younger than 18) or 1 (18 or older)

What was the difficulty to come to this solution from my sql-code?

hth anyway

thorpe

i must say 'bigrollerdave' has posted the most ungratefull reply ive seen on this board so far. did you search for these terms before asking your question?

in fact......

i wont even go into it.

batman

To keep things simple, i'm just going to say this. Why waste time on such a worthless script? If the person (the kid unger 18) doesn't at first lie about his / her age, then what would stop them from hitting the back button to change the birthyear once they find out they have to be 18? There is no way to actually block out an underaged child from entering a site. The best you can do is post a warning of some kind letting them know they have to be 18+ so nothing falls back on you. Thats my .02!

bigrollerdave

Originally posted by batman
To keep things simple, i'm just going to say this. Why waste time on such a worthless script? If the person (the kid unger 18) doesn't at first lie about his / her age, then what would stop them from hitting the back button to change the birthyear once they find out they have to be 18? There is no way to actually block out an underaged child from entering a site. The best you can do is post a warning of some kind letting them know they have to be 18+ so nothing falls back on you. Thats my .02!

lol a simple i dunno would have done just fine

batman

Why would I have posted an answer when there is one right above me posted by mrhappiness?? I was just saying that it's a lame idea...:rolleyes:

bigrollerdave

Users cant change there age after signup sure they could lie about there age at signup but then its on them not me