Change mysql extensions

I want to allow people to download videos off my site.

But the uploaded extensions all end in .mpg .avi etc

Basically want to still get the video name - {$answers[i].videoname}, but change the last extension from whatever to .zip.

Can this be done ??

What does this have to do with mysql?

Because the information is within mysql tables

[B]carefree wrote on Sat, 22 September 2007 09:28[/B]
Because the information is within mysql tables

You can just change the output to the end user dynamically, or change the extension before it goes into mysql…

.mpeg = .whatever to end user
then as they try to download it
your front end script changes it
back to .whatever to .mpeg