database image path

shahrinn

hi all,
my client store image in table using image path

current image path in table : ../../image/23.jpg
my localhost structure : http://localhost/staffsystem/staffdetail.php

i call image from php code using :
$image = odbc_result($rs,"staffimagepath");
<img src="<?php echo $image; ?>"

if i change the image path inside the table to staffsystem/image/23.jpg it success display the image but if using the ../../image/23.jpg the image failed to show

hope someone can guide me

thanx.

leatherback

Hi Sharinn,

The relative path is obviously wrong in the database; Did you move the directory with the actual images and/or the page using the images?

What guidance are you looking for?
You could solve it
- by moving the page using the images (Not ideal, as incoming links will fail to find your page)
- By having your script change the path each time the image is used (possible &straightforward using the file functions)
- By moving the images directory to match the path
- By removing all paths from the database, and only adding a path (somewhat complex, but in my view the ideal solution, as it stimulates flexibility in use of the database).