Your $eventdate variable is an array, not a string so you can't just
drop it into an sql query string like that.
If you have separate fields in the db for year, month and day then you
probably want something like:
$query = "insert into ... values ( ... , '$eventdate[0]',
'$eventdate[1]', '$eventdate[2]', ...)";
Otherwise, if they're all supposed to go into the same field then do
something like:
$eventdatestring = join("-", $eventdate);
$query = "insert into ... values ( ..., '$eventdatestring', ...)";
This should insert the date in the form "eventyear-eventmonth-eventday";
-Steve
On Monday, April 15, 2002, at 03:13 PM, Alex Francis wrote:
> I am trying to insert event dats into a database and to make sure the
> user
> puts the date in the correct format. I am now trying to collect the
> information from the three fields and insert it into one field.
>
> code as follows: $eventdate = array ("eventyear", "eventmonth",
> "eventday");
>
> when I insert it into the database like: $query = "INSERT INTO
> $tablename4
> VALUES ('0', '$entername', '$date', '$eventdate', '$eventheading',
> '$eventbody' )";
>
> for the $eventdate variable the word "array" is inserted.
>
> Could someone please tell me where I am going wrong.
>
> --
> Alex Francis
> Cameron Design
> 35, Drumillan Hill
> Greenock PA16 0XD
>
> Tel 01475 798106
> [EMAIL PROTECTED]
> http://www.camerondesign.co.uk
>
> This message is sent in confidence for the addressee only. It may
> contain
> legally privileged information.
> Unauthorised recipients are requested to preserve this confidentiality
> and
> to advise the sender
> immediately of any error in transmission.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
