Re: How to Replace the table data

no it's working (successed), but nothing was updated. I tried to make a fake table. when i tried to make a fake table its working. i tried to change "ABC" from the table to "XXX" but if i got data called ABCD , it didnt change to XXXD why ? --- "Jason Wong" <phplist@gremlins.com.hk> > 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 > >When you say it's not working do you mean nothing was updated? Or there was >an error message? If so what was the error? Have you tried running the same >query using the mysql client? > >> 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 >Gremlins Associates >www.gremlins.com.hk >Tel: +852-2573-5033 >Fax: +852-2573-5851 > > > > >-- >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