spend time

[bmwmpower]

i make table for add the name of the user when he login the website and add the time for login and the time for logout
what i need is how many time the user spend in the website

time spend =time login-time logout
how i can make that in SQL

so i must add new record for the time spend or i can writ the result in the page only

[Mhtml]

Hmm... Not sure exactly how you want to relate this with the database but to get the difference in time use datediff().. Search this forum for help on using it there were a few good posts.