Date and Time

[Trium918]

I am trying to create a script that will store the user registeration date in a database so that I can keep track of the user last visit to my website. If anyone can help me, I will be more than happy to accept any ideas of where to start first.



[code=php:0]$host="localhost";
$database="Date"; //The name of the database
$dusername="root";
//$dpassword="";
$x=mysql_connect($host,$database,$dusername/*,$dpassword*/);
$x1=mysql_select_db($database)
or die("Could not select Date database !");
/*$user_date is the name of the column in the database but
how do I insert the user register date into the variable $user_date
so that it can be stored inside $user_date which
will be stored in the database called Date?*/
$query="INSERT into Date Values('".$user_date."')";
$result=mysql_query($query);
if (!($result)) { die("User Register date could not be stored"); } [/code]

[paul2463]

[code]
<?php
$user_date = date("Y-m-d"); //this is the date NOW
$query="INSERT into Date ($user_date) Values ('$user_date')"
$result=mysql_query($query) or die("User Register date could not be stored");
?>
[/code]

[Trium918]

Paul2463, when I try it your way, the [code=php:0]or die("User Register date could not be stored");[/code] is the result that I am getting.

[papaface]

try:
[code]
<?php
$user_date = date("Y-m-d"); //this is the date NOW
$query="INSERT into Date ($user_date) Values ('".$user_date."')";
$result=mysql_query($query) or die("User Register date could not be stored");
?>
[/code]

[AndyB]

Change the error messaging so it's more helpful while testing:

$result=mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

What is name of the [b]table[/b]?