time stamp screwing up
| From: | - \[ Paul Ferrie \] - | Date: | Mon, 06 Jan 2003 16:19:07 +0000 |
| Subject: | time stamp screwing up | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-130422@lists.php.net to get a copy of this message | ||
hey guys could someone help me
I have created a user login register system in flash with PHP and Mysql.
Everthing Now works fine aprt from the time stamp of when the user
registered.
Code -----------------------------------
// Get current date & time
$time = time();
// Connects to the Database.
$Connect = mysql_connect($dbServer, $dbUser, $dbPass);
mysql_select_db("$dbName");
// Preforms the SQL query to see if user name already exsists
$query = "SELECT name FROM contacts WHERE name='$name'";
$rs_contacts = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($rs_contacts);
if ($row[name] == $name) {
print "loginT=UserName in Use&checklog=2";
}else{
$query = "INSERT INTO contacts (id, name, pass, email, dateAdded) VALUES
(NULL, '$name', '$pass', '$email', '$time')";
}
It inserts 0000-00-00
instead of the current date
ideas
P.S
I am a newbie try keeping reponse's simple please