Instead of the php function, 'time()'. Try 'date()'. Somethine like this
--clip--
<?
//Long way around
date("Y")."-".date("m")."-".date("d");
//Shortcut
date("Y-m-d");
?>
--clip--
You can customize the way you want the time format to be displayed. You can
find it at http://www.php.net/manual/en/function.date.php and you'll see the
option for dates and times.
"- -" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
