Hi,

But won't update update the what I input.  I only need
PART of the post to update, only the selected url area
and want the remaining of the message to be unchanged.
 Won't the update change the whole message?  I think
it does, I only need part of the message to be edited
and that is the URL the text needs to be unchanged.

I have over 9,000 posts to update and fix the image
url for it.  I can't afford to muddle up the posts.

Jerry

From: "Jason Wong" <[EMAIL PROTECTED]> 
To: [EMAIL PROTECTED] 
Date: Thu, 17 Jul 2003 13:43:17 +0800 
Subject: Re: [PHP-DB] editing part of a fiedl! 

On Thursday 17 July 2003 12:28, JeRRy wrote:

> 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?

Use an UPDATE query.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet
Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
The little pieces of my life I give to you, with love,
to make a quilt
to keep away the cold.
*/




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

Reply via email to