I have created some code that grabs a quicktime movie from my db and send it to the browser... it works... but the sound doesn't play and after about 2 seconds of video it stops and the video player screen turns green.
here is the code i am using:
<?php
include ("dbconnect.inc");
if ($id == ""){print "You need to specify an image id!";}
else
{
$result = mysql_query ("SELECT video.video FROM video WHERE video.id LIKE '$id'");
if ($row = mysql_fetch_array($result)) {
do {
$pic = ($row["video"]);
if ($pic == ""){echo "video has data";}
else
{
Header("Content-type: video/quicktime");
$video = ($row["video"]);
echo $video;
mysql_query ("UPDATE video
SET video.views=video.views+1
WHERE id LIKE '$id'
");
}
} while($row = mysql_fetch_array($result));
} else {
echo "no video with that id";
}
}
echo $video;
?>
am i attempting the impossible??? it works great with jpgs!
-dave
