show flash file from database

[matthew9090]

I have got a flash file that is stored in the database. So I fetch it and put it in a variable then put the variable in the flash embed code where the src is but the flash comes up blank.

 

$file = "SELECT * FROM table WHERE column='$name'";
$file2 = mysql_query($sqlfile);
        $file3 = @mysql_fetch_assoc($file2);
$file4 = $file3['gamefile'];
  //skip some code to html embed section
<object width='550' height='400'>
<param name='movie' value='valuename'>
<embed src='$file4' width='550' height='400'>
</embed>
</object>

    

 

then the page comes up with a white box which when you hover over it says 'file not loaded'.

[blacknight]

$file = "SELECT * FROM table WHERE column='$name'"; $file2 = mysql_query($sqlfile);

 

should be

 

$sqlfile = "SELECT * FROM table WHERE column='$name'"; $file2 = mysql_query($sqlfile);

[matthew9090]

when i view the html of the page it comes up with the embed src as nothing

[AbraCadaver]

You're not echoing the var in the HTML:

 

<embed src="<?php echo $file4; ?>" width="550" height="400">