making timecodes

da_marek

hello!
i have a file in which i have to store two times (start & end) of a movie and an image name. it should look like this:

No.           Start         End          Image
--------------------------------------------------
1          00:00:41:00  00:00:46:00  image_001.tif
2          00:01:07:00  00:01:11:19  image_002.tif
3          00:01:36:07  00:01:38:22  image_003.tif
etc.

the times are generated from the form in which i have to insert number of seconds and then add or substract that number from existing starting/ending times...

for example:
the times in data.txt file are like those above. i insert number 10 in form and the script overwrites data.txt with these values:

No.           Start         End          Image
--------------------------------------------------
1          00:00:51:00  00:00:56:00  image_001.tif
2          00:01:17:00  00:01:21:19  image_002.tif
3          00:01:46:07  00:01:48:22  image_003.tif
etc.

if i insert -10 in my form it should overwrite data.txt with times that are 10 second before, like this:

No.           Start         End          Image
--------------------------------------------------
1          00:00:41:00  00:00:46:00  image_001.tif
2          00:01:07:00  00:01:11:19  image_002.tif
3          00:01:36:07  00:01:38:22  image_003.tif
etc.

any suggestions how to do that please? i don't have nothing yet and any help would be great!

weekender

instead of storing the data tabulated like that, i'd store it in csv fomat - see [man]fgetcsv[/man]

but it would be much easier if you were going to store it in a database - do you have access to mysql?

da_marek

maybe it would be easier but i have to make txt file at the end... if it is very complicated then i guess i'll have to make it through mysql but i'd rather avoid that... i don't know about CSV so i have to check it out first...