Trim Value

[seran128]

I have a feild in my table called path this shows the full path of a file like

/home/jeffnort/public_html/site1/GarageSaleImages/de126f931451872c80680e72ca3ac4df.png

What I need is just the
GarageSaleImages/de126f931451872c80680e72ca3ac4df.png

part

what can I use to trim

/home/jeffnort/public_html/site1

[joshi_v]

$test="/home/jeffnort/public_html/site1/GarageSaleImages/de126f931451872c80680e72ca3ac4df.png";
$test=substring($test,1);#This will removes the first "/" in the string.
$testarr=explode("/",$test);#Forming an array with the breaking character "/".
$testarr=arrreverse($testarr)# This will reverse the array .

$final_string=.'/'.$testarr[0].'/'.$testarr[1]; #this will form the fianl strign with last two fields of the array.

Regards
Joshi.

[fenway]

You can also run a replace() in mysql if you know that's a fixed strin.