austine_power007 Posted December 18, 2006 Share Posted December 18, 2006 I use some code it like:[code]<input type=\"text\" name=\"act_dat\" value=\"{$actual[0]}$actual[1]\" size='01'><span class='style12'>dd</span><input type=\"text\" name=\"act_mon\" value=\"{$actual[3]}$actual[4]\" size='01'><span class='style12'>mm</span><input type=\"text\" name=\"act_yr\" value=\"{$actual[6]}$actual[7]$actual[8]$actual[9]\" size='01'><span class='style12'>yy</span>[/code]it return me date in three text field like: 20 12 2006 then i took three field and make it a varibale [code]$act_date=$_POST['act_dat']; $act_month=$_POST['act_mon']; $act_year=$_POST['act_yr']; $actual=$act_month.'/'.$act_date.'/'.$act_year;[/code]then i update the database[code]$query = odbc_exec($odbc, "UPDATE task SET actual_end_date = $actual,complete = $complete, remark = '$remark' WHERE title = '$title'") or die ("Wrong data");[/code] after update, it shows me some error: :'([code]Windows does not support dates prior to midnight (00:00:00), January 1, 1970 [/code]Can any one help me out?? Quote Link to comment Share on other sites More sharing options...
austine_power007 Posted December 18, 2006 Author Share Posted December 18, 2006 Yesss i solved the problem it is only for the ' ' around the $actual in Update field Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.