inserting into DB

[harkly]

I want to be able to calculate the ages of my users. I thought that if I inserted the bd into the database as yyyy-mm-dd it would be easier to do this. However, my form gets the year, month and day separetly. I thought that combining them and inserted into db would be a good idea. I am able to get them to combine but not insert into the db. can some help me??

            $bd_day=$_POST["bd_day"];
            $bd_month=$_POST["bd_month"];
            $bd_year=$_POST["bd_year"];
            $birth_date= $bd_year."-".$bd_month."-".$bd_day;

 

            $sql = "INSERT INTO user 
                (bd_day, bd_month, bd_year, birth_date)
              VALUES
	('$_POST[bd_day]','$_POST[bd_month]','$_POST[bd_year]','$_POST[birth_date]',NOW())";

 

Makes sense to me that this would work but I have never tried inserting like this before and am pretty new

[mapleleaf]

For birth date don't use $_POST in the insert query as it wasn't Posted.

[harkly]

still not working

 

removed the $_POST

 

  VALUES ('$_POST[bd_day]','$_POST[bd_month]','$_POST[bd_year]','[birth_date]',NOW())";

 

and tried with the [] removed as well

[harkly]

Got it!!

 

Stupid me forgot to put the $

 

Thanks!!!!

 

Now off to figure out how to calculate age  :-\