|
Posted by Harris Kosmidhs on 09/11/07 09:28
Kevin Raleigh wrote:
> I would like to create a searchable database containing audio messages and
> video messages.
> Would I just create a file path to the folder containing the audio and video
> files?
> I would also like to use PHP to list just the last N messages.
>
> How does Amazon store it's audio files?
>
> Kevin
The DB scheme can be the same. But instead of a binary BLOB you can have
a varchar holding the filename (or directory).
For example SELECT filename FROM myadio ORDER BY date_stored DESC LIMIT
0,10 (last ten)
Then for each filename you can get the contents of tour file.
Hope it helped
Harris
Navigation:
[Reply to this message]
|