m3rajk — Mon, 17 Nov 2003 03:50:05 +0000

the little things are often the hardest to see.

i would have answered sooner if i got back sooner.

it's moot now, but i would have pointed out you initially used date and were using getdate with what i had and told ya to check em both.

hint for next time, check similar functions on php.net.

brady.k — Sat, 15 Nov 2003 04:04:02 +0000

awesome...I can't believe it took that long to figure out the order was wrong...lol

thanks mark.

Mark Hensler — Fri, 14 Nov 2003 06:42:47 +0000

hehe.. ok, after reading through the thread. You've all got the concept, but have the wrong format for timestamps.

"year-month-day hours:minutes:seconds"

As far as I know, it's only we funny Americans who use the "month day year" format. Which to me, makes really no sence. Thats like "two hundred and four and thirty". The order has no relation to magnetude. Whereas "year month day" does.

Mark Hensler — Fri, 14 Nov 2003 06:36:23 +0000

Eskater05, just change your date() line to:
$date = date("Y-m-d");

druagord — Thu, 13 Nov 2003 22:13:57 +0000

ok i'll show you how

<?php
 $date = getdate();
$query = \"INSERT INTO table (info, date) VALUES ('\". $_POST[info] . \"', '\" . $date['mon'].\"-\".$date['mday'].\"-\".$date['year'] . \"')\"; 
?>

brady.k — Thu, 13 Nov 2003 22:08:33 +0000

no, it was orginially date, then it was changed to varchar(10) for the $date=3 test, and now it's back to date

and druagord, i know that. i tried every different time function listed on php.net just to try and get one to work.

Busy — Thu, 13 Nov 2003 09:30:34 +0000

what is the data type of your 'data' database field?

it's not something like varchar(1) or anything is it?

druagord — Thu, 13 Nov 2003 04:02:48 +0000

getdate does work like this it will return a array contaning date info check this link to see how you can get values
http://www.php.net/manual/en/function.getdate.php

Suzanne — Thu, 13 Nov 2003 02:44:18 +0000

"3" is not a date.

brady.k — Thu, 13 Nov 2003 02:23:01 +0000

alright, well...i did a little test...i set $date=3 and then ran the php script with

<?php
.\",date=$date\"
?>

and it returned 3 in the MySQL db

but when i set $date= getdate(m-d-Y); it does nothing. my field shows up as blank in the db.

m3rajk...i tried what you said, none of it worked...

could this be a server problem since it doesn't display the time?