getdate array

[lilRachie]

This is only a portion of my code, but will this work for array?

$time=getdate();

$insert_mail = ("INSERT INTO table (email,password,ip_address,date) VALUES ('$mail','$password','$ipadress','$time[mon,mday,year,hours,minutes])");

😕

lilRachie

[barand]

Use [man]date[/man] to format the date. Also, in SQL the word date is reserved, so if you have a field of that name you need to enclose it in backticks (`).

$thedate = date("m d Y H:m");

$insert_mail = "INSERT INTO table (email,password,ip_address,`date`) VALUES ('$mail','$password','$ipadress','$thedate' )"; 

hth

[lilRachie]

that is awesome
thanks for the new knowledge

😉

kiss

lilRachie