At 12:58 AM 22/11/2004 +0200, you wrote:

>Hi
>Thx!
>Now I am stuck here in line 37
>ibase_query("UPDATE users SET last_login_date = getdate() WHERE
>userid='$userid'");
>now() and getdate() gives me errors like
>Warning: InterBase: Dynamic SQL Error SQL error code = -804 Function unknown
>GETDATE in /home/e-smith/files/ibays/Primary/html/mc/checkuser.php on line
>37

Yup. GetDate() sounds like some internal function of a non-standard SQL
system. Use the context variables CURRENT_TIMESTAMP or CURRENT_DATE to get
the server timestamp or date, according to the type of last_login_date.

BTW, you can also use CURRENT_USER directly in your update statement, if
your $userid actually represents the current user v/v. security.fdb.

Helen