Re: Retrieve large amounts of binary data from MySQL database in pieces
| From: | Barry | Date: | Tue, 21 Mar 2006 09:31:12 +0000 |
| Subject: | Re: Retrieve large amounts of binary data from MySQL database in pieces | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-232301@lists.php.net to get a copy of this message | ||
Michael Thomsen wrote:
Hi, I was wondering if anyone knew how to retrieve large amounts of binary data from a MySQL database without having it loaded all at once into a PHP data structure. I'd like to be able to iterate over the result, pulling out 16kb or so of data at a time and feed it to the browser. Any suggestions? Thanks, Mike With the SUBSTRING function of MySQL.This question belongs more to a MySQL mailing List. And read the manuals! Took me 5 secs to find that function. Be glad that somone is in a good mood to help such a lazy guy like you. Greets Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)