Re: time stamp screwing up

nope it still comes up with all the zero's :( "Stephan Seidt" <blizz@0x03.net> wrote in message news:3E19AEE0.7080603@0x03.net... > What sort of mysql field type did you use for dateAdded ? > You need UNIX_TIMESTAMP (or sth like that) for unix timestamp format. > > - [ Paul Ferrie ] - wrote: > > 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 > > > > > > > > > -- > When ipv6 and tcpa are there.. When this Palladium server wrecks.. > I won't be able to drink my coffe then! >