Pictures from MySql

[ragrim]

Hi,

Before anyone says anything YES i have googled this and yes i found many helpfull things, none of which work in my current situation!

im using PHPRunner and it has built a search page and etc for me and displays data from my database perfectly but i want to display pics! ive added the image name IE: picture.jpg to the picture field in my database but im not sure where to go from there because the code that PHPRunner creates is unlike anything ive seen before.

This is the code

//	picture - 
	$value="";
		$value = ProcessLargeText(GetData($data,"picture", ""),"","",MODE_VIEW);
	$smarty->assign("show_picture",$value);

Since im still a beginner im not sure how to modify that to display a pic.

Thanks in advance!

[rulian]

I'm not sure what those functions you calling are, but basically when you store a picture in a database you dont store the image itself in the database, but only a reference to the image file.

For example, lets say I uploaded an image called "mypic.jpg" into a directory called "user_images" on the server. the URL for the image would be (relative) "user_images/mypic.jpg"

So in my database, when I store the image, I dont store the image code itself, but rather just the URL to the image, so lets say this given table scheme
"ID | Person | Picture"
has in it
"1 | Billy | user_images/mypic.jpg"

when I query the database for rows, I simply include the URL for the image in a <img> tag and the image will display
the <img> tag has to be generated by php of course