embedded windows media file

[ettico]

hello,
i'm trying to dynamically generate a windows media file based on info pulling from a database. The code I've used gives me a parse error:

?php

$dbh=mysql_connect ("localhost", "ettico05_admin", "admin") or die ('I cannot connect to the

database because: ' . mysql_error());
mysql_select_db ("ettico05_nuke");

$result = mysql_query("SELECT * FROM mediaplaya WHERE media_id=1");

<OBJECT

ID="mediaPlayer"

CLASSID="CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95"

CODEBASE="http://activex.microsoft.com/activex/
controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701"

STANDBY="Loading Microsoft Windows Media Player components..."

TYPE="application/x-oleobject">

print <PARAM NAME="fileName"
VALUE="/media/$media_filename">

<PARAM NAME="animationatStart" VALUE="true">

<PARAM NAME="transparentatStart" VALUE="true">

<PARAM NAME="autoStart" VALUE="true">

<PARAM NAME="showControls" VALUE="true">

?>

Has anybody ever tried this?

Thanks in advance.

Ken

[hermzz]

you should probably try to echo it..
as in:

<?php 

$dbh=mysql_connect ("localhost", "ettico05_admin", "admin") or die ('I cannot connect to the 

database because: ' . mysql_error()); 
mysql_select_db ("ettico05_nuke"); 

$result = mysql_query("SELECT * FROM mediaplaya WHERE media_id=1"); 

echo "<OBJECT
ID="mediaPlayer" 
CLASSID="CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95" 
CODEBASE="http://activex.microsoft.com/activex/ 
controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701" 
STANDBY="Loading Microsoft Windows Media Player components..." 
TYPE="application/x-oleobject"> 
print <PARAM NAME="fileName" 
VALUE="/media/";
echo $media_filename;
echo "'>
<PARAM NAME="animationatStart" VALUE="true"> 
<PARAM NAME="transparentatStart" VALUE="true"> 
<PARAM NAME="autoStart" VALUE="true"> 
<PARAM NAME="showControls" VALUE="true"> 
?>  

things to change: remeber to change the " to ' or use the /
there is also another method, with printf or print i dont remeber which, which alows to do this in only one echo. as in:
printf or whatever it is ("all the object thing before the variable" $variable "and the rest");
also i think there shlould be a closing qoute like </object> or somthing.

[jayant]

$media_filename will be empty. you have not initialized it anywhere. Use $result to get path to media file and assign to $media_filename.

like:

$result=mysql_fetch_array($result);
$media_filename=$result[1];

giving it just after mysql_query. you might need to change $result[1] to $result[X] depending upon the table structure and query structure.