REFUSING to add an entry!!!!

[pablodelapena]

I have been playing with this script for a while now an it still REFUSES to add the time entry.

I am using this table to determine whos been active in the past 20 mins. Although it just will NOT add my time entry into the database.

//we give the user a session start time using the time(); function
$sessionSTARTTIME = time();

$query = "INSERT INTO sessions (sessionID, session_username, sessionIP, sessionSTARTTIME, donator) VALUES ('$sessionID', '$username', '$sessionIP', '$sessionSTARTTIME', 'no')";
$result = mysql_query($query);

Why wont it add it to the table? Everytime i check it it is simply zero in pgpMyAdmin1!!!!

[FraXTC]

Did you declare that the record you save your time in is a time record? Maybe that will work... And I don't know what system u use, but isn't it handier to just take the current time whenever a user is online, save it in a DB , then everytime you want to know who where online in the past 20 mins you just take the current time , substract 20 mins and query for all the times that are newer then the new time?

[scoppc]

try to print what you got in your $query.
Review the sql statement and you'll probably see your problems.

[cosminb]

use mysql_error() to check for sintax errors in your query