FYI : POST_TXT = text field & Not null = YES
--- Nagasea <[EMAIL PROTECTED]>
> wrote:
>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]
_____________________________________________________________
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]
