Storing/Retrieving SWF to MySQL

[lessterm]

Hi anyone here know how to retrieve a flash ".swf" from a database and display it on the browser? I can store but I when I query it, It wont display. And one more thing, if I place my flash ".swf" and store it's name to my database which most people say is conventional, How can I call that ".swf" file in my directory after I query it's name from my database?

[rachel2004]

For the first part of yoru question, when you say it won't display, it could be because of the data type that you stored the swf as in your database is not appropriate. You should be using a data type like BLOB. That is just a suggestion as I normally do not store graphics or such in my db. For the second part of your question, if you have a .swf called test.swf and it is located at:

/home/lessterm/movies/test.swf

you would want to store either the entire path or part of the path (e.g. /movies/test.swf if the /home/lesstern never changes) in the database. For that, using varchar as your data type for the column would suffice. Later on, if you want to use your .swf for something, you need to query for it:

SELECT * FROM table_name WHERE id = '20';

That will retrieve the path of the .swf which you could assign to a variable or whatever you want to do.

[lessterm]

Thanks, I got the second part. But Im still trying on my first question. I can store the file, that is a BLOB and when I retrieve it after querying, It wont display. I got the correct header content-type for flash - header("Content-type: application/x-shockwave-flash");

[rachel2004]

Can you post your CREATE TABLE statement so I can see what we're working with and also post the code that you are using to INSERT the .swf file so I can see what you're doing that may have caused a problem when you do your SELECT statement.