I have this query
$db1 = "INSERT INTO tablename
(name,email,phone,room,problem,upgrade,software,hardware,printer,network,os,
priority,submitdate)
VALUES
('$name','$email','$phone','$room','$problem','$upgrade','$software','$hardw
are','$printer','$network','$os','$priority','1996-05-01')";
$cur1 = MSSQL_QUERY($db1);
But when I do a select of the submitdate field, it always turns up as
today's date no matter what I try to insert. Do I need to change the format
of my date before I insert it somehow? The submitdate field is of type
smalldatetime
Thanks,
Aaron
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
