Referencing in Mysql

[idnoble]

Hello

i'm trying to use video clips in mysql database, but i don't want to put the video file in the database, instead i want to link the database to the folder where the video file resides by way of referencing, so that mysql can get the the file when required and replace it when it finishes working on it.

Does anyone knows how to do this. I'm using PHP too.

[Norman_Graham]

Hi Idnoble

You just do a MySQL query and then stick the path to the file in the link, i.e.

$sql=mysql_query("SELECT vid_file_path FROM mytable WHERE ID='$id'");

$result=mysql_fetch_array($sql);

print "<a href=\"" . $result["vid_file_path"] . "\">Check out this vid!</a>";

Does that answer your question? To the best of my knowledge, you can't 'reference' anything in the database in the way you mean, i.e. you call up the file path from the DB and it automatically calls up the vid file.

HTH

Norm

[Erkilite]

your best bet is to store the filename and location of the video file on your server in the db. then just use that when you want to access the video from php.