I don;t know why it's still not working.
I tried it with smaller table and it works.
but when I tried with my real table, it's not working
I use this :
UPDATE posts SET post_text='IMG SRC="<IMG SRC="/serv2/big/forum/images/smiles' WHERE
post_text='<IMG SRC="/gmns/BB/images/smiles'
FYI : posts_text = text field (NOT NULL=YES)
--- "Jason Wong" <[EMAIL PROTECTED]>
> wrote:
>
>
>> its not working because it's not a variable (url)
>> it's a text field
>
>'url' is the name of the field which contains "http://something.com/".
>Replace it with the name of the field in *your* table which contains
>"http://something.com/".
>
>BTW as Terry pointed out (I misread your question) the update query should
>be:
>
>UPDATE table SET url='http://something.com/target' WHERE
>url='http://www.something.com/'
>
>regards
>--
>Jason Wong
>Gremlins Associates
>www.gremlins.com.hk
>Tel: +852-2573-5033
>Fax: +852-2573-5851
_____________________________________________________________
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]