Hi everyone. I am trying to make a table that when people edit something from it, it will show the date it was edited.

This is my code:

Code: ( php )

$date = date("m/d/Y");
mssql_query("INSERT INTO news2 (title, dtime, text1, text2) VALUES ('$title', '$date', '$text1', '$text2')");

The thing is that when I check the table, the time is messed up. It shows 4/11/1900 instead of 01/21/2008.

I tried using now() instead of '$date' but I get the following error:

Warning: mssql_query() [function.mssql-query]: message: Syntax error converting datetime from character string. (severity 16) in C:\xampp\htdocs\news2.php on line 22

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\news2.php on line 22

Also, is there a way I can add the time next to the date into the database?

Btw, is there a way I could insert the date into the database like this: 12:50am 31/12/2008

Thank you
~ SalokinX

    I fixed the problem with a pretty longer code. At least it worked.

    	$dia = gmdate(d);
	$mes = gmdate(m);
	$ano = gmdate(Y);
	$minuto = gmdate(i);
	$date = gmdate(H);
	$brdate = $date - 2;
	$brdate2 = $brdate;

if($brdate < 0)
	{
	$brdate2 = $brdate + 12;
	$ampm = "PM";
	}
elseif($brdate == 0)
	{
	$brdate2 = $brdate + 12;
	$ampm = "AM";
	}
elseif($brdate <= 11)
	{
	$ampm = "AM";
	}
elseif($brdate == 12)
	{
	$brdate2 == $brdate;
	$ampm = "PM";
	}
elseif($brdate >= 13)
	{
	$brdate2 = $brdate - 12;
	$ampm = "PM";
	}

if($brdate2 < 10)
	{
	$hora = "0$brdate2:$minuto$ampm";
	}
else
	{	
	$hora = "$brdate2:$minuto$ampm";
	}

$adddate = "$hora $dia/$mes/$ano";

      It can be shorter:

      $adddate = date('h:iA d/m/Y', strtotime('-2 hours'));

      Which I suspect would also be more accurate (in the code you've written, you don't take into account the possibility that two hours ago it might have been yesterday. Or last month or last year, for that matter).

        Yeah I did. I tried every hour and it works perfectly.

          Write a Reply...