need some help on stratagy... (php/mysql/javascript)
| From: | Alexander Ross | 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