tgavin — 2012-02-07T20:31:41-05:00 — #1
I have several fields, one of which is a BLOB. I want to SELECT the fields and return the results to the browser, and then dump the contents of the BLOB into a file on the server. I'm struggling with how to do this in one query. The on_linear_array field is the BLOB.
r937 — 2012-02-07T20:44:57-05:00 — #2
return the results to the browser??
isn't there an application language in between mysql and the browser? like php or something?
tgavin — 2012-02-07T20:50:00-05:00 — #3
Ha! Yes, Mr. Literal, I'll be using PHP to print the results to the browser.
r937 — 2012-02-07T21:34:25-05:00 — #4
okay, so php retrieves the data from the database and saves the blob to the file
i don't do php or i'd help you further
tgavin — 2012-02-07T21:36:57-05:00 — #5
The query is the problem; it's putting all of the results into the file. I figured I'd written it incorrectly. Hmmm...