displaying images

[rooks]

Hi,

First off I am still in the very early stages of php / mysql (like a couple of days).

I have added a VARCHAR field to a table in phpmyadmin to hold image links (and I can see the image thumbnail here). Then using Dreamweaver I have drawn a table & created a Recordset, with bindings to display the whole table for a record, code as follows:

table width="800" border="0">
<tr>
<th width="131" scope="row">address</th>
<td width="659"><?php echo $row_Recordset1['address']; ?></td>
</tr>
<tr>
<th scope="row">price</th>
<td><?php echo $row_Recordset1['price_per_mth']; ?></td>
</tr>
<tr>
<th scope="row">pic</th>
<td><?php echo $row_Recordset1['pic1']; ?></td>
</tr>

Is there anything relatively easy that I can change here so that the actual image ('pic1') displays, as opposed to just the path, preferably without delving deep into the depths pf php? Please be gentle with me!

Thanks a lot, much appreciated

[dagon]

change

<td><?php echo $row_Recordset1['pic1']; ?></td>

to

<td><img src="<?php echo $row_Recordset1['pic1']; ?>"></td>

assumes stored path is absolute

[rooks]

wow, thanks so much man, that worked a treat. i will be sure to spend some time working out the logic behind that

thanks again
rooks

[johanafm]

The logic behind it is how the browser deals with different HTML elements, in this case a "replaced element"; i.e. the element does not contain the data to be used - it just indicates where to get it. The URL to the image is nothing but text to the browser, unless it appears as the src attribute value of an image element. Whenever the browser encounters an image element, it sends a new request to the server indicated by the src attribute, and if everything works as it should, the response contains the image data, which is then displayed.
Link, script and object/embed elements work in the same way.