Search engine displaying picture

[davidewebit]

Well.. my table contains name VARCHAR
description VARCHAR and picture LONGBLOB
(I use it to upload images to my_db).

I tried to run a search engine php script
This script works with a WHILE LOOP but
it works fine just for 'name' (it is varchar)
and 'description' (varchar)
It doesn't work for 'picture' (it's a LONGBLO😎
I think it's just a syntax lack of something
Look the code.... (while loop already started......)

echo $result['name'];
echo "<br>";
echo $result['description'];
echo "<br>";
echo $result['picture'];
echo "<br>";
}

Maybe something to add for worning there's an image to be displayed at line

echo $result['picture'];

I hope someone will understand what I said....

Help needed...
Thanks to all anyway !

[davidewebit]

I forgot to say that writing the script

echo $result['picture'];

the search result a scrolling down of letters and numbers and chars on my browser
that's why I'm thinking about something to add as Header "Content type.... but how?? Do not know syntax... help pls... thank you all !

[davidewebit]

I forgot to say that writing the script

echo $result['picture'];

the search result a scrolling down of letters and numbers and chars on my browser
that's why I'm thinking about something to add as Header "Content type.... but how?? Do not know syntax... help pls... thank you all !

[BlueKai]

It's not good practice to store images in a database. Store the pathname and echo an html img tag.

[davidewebit]

You're right...

that's how I just solved it out !!!

Thank you anyway !!!
Thank you all guys !!!