Re: How to Replace the table data

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