need some help on stratagy... (php/mysql/javascript)

From: Date: Tue, 23 Jul 2002 13:44:32 +0000
Subject: need some help on stratagy... (php/mysql/javascript)
Groups: php.general 
Request: Send a blank email to php-general+get-109081@lists.php.net to get a copy of this message
I have an embedded object in my webpage which will play a DVD movie right in the page (provided you have a disc in teh dvdrom drive). One of the javascript methods attached to this object returns the current time. OK, on to the php/mysql part. I have a mysql database which has a table to catalog camera shots digramed like so: ___________ |*shot_num | | start_time | | end_time | |__________| * = primary key During play, I have a javascript function which continuously gets teh current time and puts it in an input field called cur_time (clever huh?). So my question is... what is the best way to have a second field called shot_num which is continuously changing? It can't be good to query the database continuously, even if it is a small query, can it? What is a good stratagy to work with here? I'm still a bit of a novice with php/mysql, so be gentle. Thanks Alex Ross alexross@bleen.net

« previous php.general (#109081) next »