Also, I appreciate any replies, and in the name of me trying to learn how this works could you please explain why it isn't working, not just how to fix it? I would greatly appreciate it.
Here is the code (respaced and all for these forums)
$sql = "INSERT INTO members (Handle,Password,Email, CreateDate,RegionGroup, AgeGroup,Sex) VALUES ('$NewHandle',password('$NewPassword'), '$email','NOW()','$region', '$age','$sex')";DB Side (MySQL) I am at
CreateDate datetime Not Null default = 0000-00-00 00:00:00
All other columns are inputing correctly, except CreateDate, which is just entering the defauly value of 0000-00-00 00:00:00
Probably as simple as giving
'NOW()'a value before the insert, such as
or it could just be some issue with me having it in upper case.
Either way, brain fried for tonight, just glad the account creation portion is working.
Also, if you know off the top of your head now to grab the users IP addess and assign it to a variable it would be much appreciated (same deal, want to into it into a column) :P