Re: How to Replace the table data

FYI : POST_TXT = text field & Not null = YES --- Nagasea <nagasea@kaskus.com> > 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" <phplist@gremlins.com.hk> >> 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: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net _____________________________________________________________ www.kaskus.com - FREE EMAIL SERVICE