Fu$#@& date don't want to be stored!

Elhombrebala

I'm trying to place de date in the database in a Timedate column, but it doesn't want to work, what I'm doing wrong?

$Sesion=session_id();
$fecha = date("Y-d-m h:i:s");
$link = mysql_connect('bla', 'bla', 'bla');
mysql_select_db("bla",$link);
$Inmo = $_GET['Inmo'];
$sql = "INSERT INTO Sesiones ( Fecha, Sesion, Inmo)" .
"VALUES ('$Fecha', '$Sesion', '$Inmo')";

YappyDog

Are you getting any error message?

Assuming you are actually executing the sql INSERT statement (your code doesn't show it), have you tried to look at the value of $sql to make sure it is okay?

Elhombrebala

The rest of the datas get inserted in to DB but Date never reach DB. No error message cuase it half works...

YappyDog

What does the $sql statement look like?

Can you echo out an example?

Elhombrebala

It doesnt echo anything?

?????
😕

YappyDog

Add a statement to your code after you have built the $sql variable, but before you execute it......

echo "<li>sql = [$sql]<br>";

Elhombrebala

sql = [INSERT INTO Sesiones ( Fecha, Sesion, Inmo)VALUES ('', '330e7ff2e47fe92e071f046c6ee02a5f', 'Laclau')]
it seems like the date is empty, but why?
I was echoing date before!
😕

YappyDog

You build a variable with a lower case "f", you use a variable with an uppercase "F" to do your insert. Different variables.

$fecha = date("Y-d-m h:i:s");

$sql = "INSERT INTO Sesiones ( Fecha, Sesion, Inmo)" .
"VALUES ('$Fecha', '$Sesion', '$Inmo')";

Elhombrebala

Fuck!
Those stupid mistakes really kill me!

Thanks a lot!