editing part of a fiedl!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Hi,

Yep the subject may sound confusing so let me explain.

I have this message board that uses PHP and mysql. 
Now I had to transfer the whole lot to my server, but
due to the change and a domain registration the actual
path to images in messages has changed.  So in the
post on the old host it shows their file format to the
image but on my server it is different.  It used to
use the directory board but now uses the root
directory of the domain.

So in the post field of the mysql it shows their
message and the image code to the image and any more
message.

So something like this:

Hi bob <img src="domain.com/emotions/board/laugh.gif">
all is well, cya!

So old posts have the wrong image location but new
posts show the correct place to the image as it's
configured to do it but old posts since they are
already in the database show up wrong.

Is there a way to edit _part_ of the post.  To fix the
image url.  Is there a mysql query I can use to edit
where board/emotions with /emotions?

I am not sure if there is a way but I expect it can't
be done but thought I'd ask.

Jerry

http://mobile.yahoo.com.au - Yahoo! Mobile
- Check & compose your email via SMS on your Telstra or Vodafone mobile.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux