Milliseconds!!

[domtate]

been trying to play around with this, but getting no where...
How would you add milliseconds to Stopwatch, and also the DB doesn't store the last time..
What would i change and also what changes to DB would be needed??

Thanks

[hachacha]

milliseconds: you can change the php function checktimer to return a different kind of timestamp. not totally sure how accurate it will be but this returns in milliseconds: SELECT ROUND(UNIX_TIMESTAMP(CURTIME(4)) * 1000)
CURTIME(4) is the current time to 4 decimal places over. i don't know how accurate it will be if you want to be looking at this on multiple screens but likely not that accurate.

storage: for my purposes i just needed this to have one row for storage so i always update that column -- line 60 in timecheck.php
but if you wanted to store each time you started and stopped the timer you would probably want to add two columns int(10) one for stop_time and total_time (or just calculate between the two start and stop times when you return those values instead of having a total_time)
change that update to store those values into the new columns on line 60.
in the startOrStopTimer function you would change it to insert a new column and store the row when the timer is started.
in the checktimer function you'd want to do a select for the last row that was created rather than where id=1 on line 28 in checktimer.

[domtate]

Thanks for the reply...
I made the changes, as stated but now the timer doesn't even start?? must be something i`m doing wrong.. but i just cant work out what... (BANGS HEAD AGAINST WALL!!)

I`ll keep on trying, and hopefully get it fixed!!

Thanks again for you reply...

[domtate]

Is there any chance you can help change the scripts? i am banging my head against the wall, everything i try just fails... obviously it a user error, on my behalf!! but i`m no PHP scripter..