create date & insert. Simple but... AARGH!

leatherback

Hi,

From a form Iam recieving date info, in year, month, day, hour, minute, second variables. I want to convert these to a timestamp, and insert these into my mysql database, in a timestamp(14) field.

This is what I did:

After getting the variables from the post array, and checking that hey are correct:

$date = mktime($datehour, $dateminute, $datesecond, $datemonth, $dateday, $dateyear);

The insert:


$insertquery = " 
insert into samples ( sa_plotnr, sa_name, sa_date, sa_crew, sa_inserted, sa_copyright) 
values 
( '$row[pl_id]', '$sample[$i]', '$date', '$crew[$i]','$_SESSION[userid]', '$copyright[$i]')";

Strangely enough, the data field is not filled. And IF I grab the timestamp from the echod query, and insert it maually, the date doesn't get close to what I filled out in the form..

I've been trying this for half an hour now, and I am pretty sick of it. What am I missing!??

Thanks

HalfaBee

$date should not be '$date' it should be just $date.
If you enclose it in ' it makes it a string not a number.

HalfaBee

leatherback

Eerh..
Yeah. that was pretty stupid. Should have seen that myself. But now for the wrong number being submitted.

Say, I create a time from:

d/m/y/h/m/s : 2001/5/4/51/0
($date = mktime($datehour, $dateminute, $datesecond, $datemonth, $dateday, $dateyear)😉

The unix timestamp becomes: 988977060988977060

In the database this gives: 20001128021000
which to me would translate to 2000/11/28/02/10/00

My mistake?

barand

Try, keeping the '$date' quotes.

$date = ('Y-m-d H:i:s', mktime($datehour, $dateminute, $datesecond, $datemonth, $dateday, $dateyear); 

$insertquery = "  

insert into samples ( sa_plotnr, sa_name, sa_date, sa_crew, sa_inserted, sa_copyright) 
values  

( '$row[pl_id]', '$sample[$i]', '$date', '$crew[$i]','$_SESSION[userid]', '$copyright[$i]')";

hth