[SOLVED] getting url's from mysql

[graham23s]

Hi Guys,

 

i have successfully stored an embed link for vidoes on my site in mysql:

 

<embed src="http://www.site.com/player/mediaplayer.swf" width="425" height="355" allowfullscreen="true" allowscriptaccess="always" flashvars="&file=http://www.site.com/flvmovies/phoenix23uk-FLV-1197160212.flv&height=355&width=425" />

 

but when i go to echo it out only this is coming back:

 

<embed src=

 

i assume it's to do with the fact its coming to a " but not sure if theres something i should be doing before inserting it into myslq or on the way out any help would be great

 

cheers

 

Graham

[redarrow]

to post html in a database

$url=htmlentities(addslashes($_POST['url']));

 

as said from above.....

 

WARNING

 

to make the database secure and code of yours intresting and re-usable just post the name of the file in then use html

[sKunKbad]

I believe when you store the html link in the database you need to add slashes before quotes, and then when you print the results of your query to the database, remove the slashes.

[graham23s]

thanks guys:)

 

Graham