Hmmm... not sure how this is done. I see someone added an example that they use substring to load 10mb of data at a time from the blob. The part I don't understand is how they loop the statements and continue to stream data to the user. If I make one pass and get 1mb of the blob...the browser is simply going to load that 1mb only, right? How do I keep looping and refreshing the users browser, or in this case, flash player? Thanks for any ideas! --- Marek Kilimajer <lists@xxxxxxxxxxxxx> wrote: > J J wrote: > > I have a case where video files (mov, flv, etc) > have > > been stored in a MySQL database as blobs. > > > > I'm loading them into a flash video player and > > everything works fine except it takes longer it > seems > > and it doesn't allow streaming the actual video. > > > > If I load the same videos with a direct link to > the > > http:// file system (/videos/file.flv) it loads in > > super-fast and allows streaming. > > > > I'm guessing mysql and/or php doesn't actually > release > > the BLOB until it's loaded it completely. > > > > > > So, is there a way to actually have PHP read the > BLOB > > and stream it as it's loading? Is there an > fstream() > > option like the fread()? > > use mysql's SUBSTRING() function in a loop > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
