Playing a movie file stored in the db

[nma]

Hi

How do I display content in a table of database (MSSQL) that content a jpeg image, and other information and when it displayed, I can click at the image to play the video (like in a YouTube).

Please help me.

Thanks.

[pbmods]

Changed thread title to better describe the problem (did you know that threads whose titles contain three words or less actually get FEWER responses?).

[nma]

Changed thread title to better describe the problem (did you know that threads whose titles contain three words or less actually get FEWER responses?).

Thanks for the info.

[nma]

I plan to store the movie files not at the database but in the database able just store a link to a movie (e.g G: drive external hard disk)

How do I choose the field type for links like that? Can anyone give examples?

Thansk

[pbmods]

Heya NMA. Welcome to TSDN!

You can store file paths and links as plain ol' varchars.

You'll probably want to do something like this:

$row = mysql_fetch_assoc($_res);
echo '
<object type="application/x-shockwave-flash data="c.swf?path=' . $row['file_path'] . '" width="400" height="300">
<param name="movie" value="c.swf?path=' . $row['file_path'] . '" />
<img src="noflash.gif" width="200" height="100" alt="" />
</object>';
 

[nma]

Heya NMA. Welcome to TSDN!

You can store file paths and links as plain ol' varchars.

You'll probably want to do something like this:

$row = mysql_fetch_assoc($_res);
echo '
<object type="application/x-shockwave-flash data="c.swf?path=' . $row['file_path'] . '" width="400" height="300">
<param name="movie" value="c.swf?path=' . $row['file_path'] . '" />
<img src="noflash.gif" width="200" height="100" alt="" />
</object>';
 

thanks for the code..I'm using sql server as my databse. will inform later if succeed.