How query results[SELECT] appear in tabular form,using an image with source fromFIELD

[lse123]

How query results[SELECT] appear in tabular form , using an image with source from the database table field "source" , and a link towards detailed page from the database table field "link" ? How to store image & link URLs IN THE DB TABLE ?

[Fumigator]

It seems like there is a language barrier here that is making your question unclear.

Are you asking how to store an image in a BLOB type column? That depends on the language you use. Try Google for an answer (i.e. +mysql +blob +php).

[lse123]

I want to store in a table field of a row a url(img & link) so build on the tabular results pages an image from this and build a "view details" link from the second stored url ? I only want store the url not the image ... what data type to use ? how to implement this on the tabular data results (get entry from table field and build the image and "details link" ?

[lse123]

Can you tell me how to (after get values [eg. $photo=image3, $details=link3] from database table), build an image and a link ?
$photo = mysql_result($result,$i,"photo");
what mysql/html syntax to use ?

<img src="../polis-land/images/search/ <?= $photo ?> .jpg" width="200" height="132" />
image3
all search results images are in ../images/search/ . is needed get from db table "image3" or "image3.img" or the whole url ? same stands for hyperlink ?
<a href="../polis-land/apartments/<?= $details ?>">
akamasvillageargaka.php