update and timestamps
| From: | Bartosz Aninowski | Date: | Thu, 13 Jul 2000 19:14:31 +0000 |
| Subject: | update and timestamps | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-6526@lists.php.net to get a copy of this message | ||
help me I have no idea what is wrong
I have following piece of code
<?
include "inc/config.inc";
$result=mysql_db_query($SQLDB,"SELECT * FROM user WHERE user = '$user' and
password = password('$pass') ");
if(mysql_num_rows($result)==0){
die ("wrong username or password");
}
$ip = getenv("REMOTE_ADDR");
$result=mysql_db_query($SQLDB,"UPDATE users.user SET time=now()+1200,
ip='$ip' WHERE user='$user'");
include "some.inc";
?>
and "update" works sometimes (I don't know why)
usualy if I reload page value 00000000000000 shows in field "time" in
database
this is how looks my datbase
Field Type Attributes Null Default Extra
id_user int(11) No 0 auto_increment
user varchar(8) No
password varchar(16) Yes
ip varchar(32) No
time timestamp(14) Yes
some people advice mo to read manuals and I found there
"illegal DATETIME,DTE,TIMESTAMPS values are converted to the "zero"
but my is not illegal
Bart