[SOLVED] inserting date

[TGM]

I want to insert date from page to mysql:

This is what I got but does work

 

<?php

$hostname = "localhost";
$db_user = "root";
$db_password = "";
$database = "users";
$db_table = "orders";

$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db($database,$db);

$query_auto = "INSERT INTO $db_table (date)
              VALUE ( CURDATE() )";
?>

 

I have a table name orders...in that table I have a date column but it only store "0000-00-00"

[ILMV]

So is it inserting any records? If it is but the date is wrong then try using now().

 

ILMV

[thebadbad]

I think the SQL syntax should be

 

"INSERT INTO `$db_table` (`date`) VALUES (CURDATE())"

[TGM]

So is it inserting any records? If it is but the date is wrong then try using now().

 

ILMV

still doesnt work...all other info is being stored except the date..it only stores 000-00-00.

[webdesco]

Hi,

how have you got the date column of your table set up, DATETIME ?

try the following, it's a silly way of doing it, but you will be able to figure out whether it is a problem with your php or a problem with the mysql table structure.

 

$mysqldate = date('Y-m-d H:i:s', time());
echo $mysqldate;
$query_auto = "INSERT INTO $db_table ('date') VALUE ( '$mysqldate' )";

good luck!