[SOLVED] UPDATE Timestamp?

[MadDawgX]

Hey there, I'm having some problems on updating a timestamp field (active) in my Table (users).

 

Here's what I got:

 

// QUERY - Get User Data
$qUserData = "SELECT * FROM users WHERE name='$LogUsername'";
$rUserData = mysql_query($qUserData) or die('Query failed. ' . mysql_error());
// Get Data
$LogId = mysql_result($rUserData,0,'id');
// QUERY - Update Last Active
$qLastLog = "UPDATE users SET active=unix_timestamp() WHERE id='LogId'";
$rLastLog = mysql_query($qLastLog) or die('Query failed. ' . mysql_error());

 

It just doesn't work. A couple things:

 

1. $LogId is returing 1 which is correct.

2. Nothing is affected in the active field of the row with id of 1.

 

- Thanx

[trq]

$qLastLog = "UPDATE users SET active='".unix_timestamp()."' WHERE id='$LogId'";

[MadDawgX]

Didn't work. Isn't unix_timestamp() a MYSQL function. I got the error:

 

Fatal error: Call to undefined function unix_timestamp() in *** on line 54

[trq]

Sorry, your right.

 

$qLastLog = "UPDATE users SET active='unix_timestamp()' WHERE id='$LogId'"

[MadDawgX]

Okay, unix_timestamp() didn't work but NOW()  did. Thanx.