<img> php mysql insert.

[TemprateRage]

not sure if this is a php or mysql question. or both...since it involves both.

Im building my site to be completely editable from online using mysql. i want to be able to add my affiliates on from online as well, but i dont feel like typing the full <img scr....etc..> in the input feild, with websites i can just put the [url]http://[/url] and it is good, is there a way, so that i can just put the url to the image in the box, and when i submit it it will show the image instead of the url?

[LordShryku]

Just add it on insert

<form>
<input type=\"text\" name=\"image_url\">";
// so they type the url of the image in here....

//next page, before inserting
$imgUrl = "<img src=\"".$_POST['image_url']."\" border=\"0\">";
$sql = mysql_query("INSERT INTO table (image) VALUES ("'.$imgUrl."')");

[TemprateRage]

kewl, thx a bunch.