Re: [PHP-DB] How to Replace the table data

2001-09-15 Thread Nagasea
cool ! that's what i wanted to say :) thank jason wong ! u da best --- "Jason Wong" <[EMAIL PROTECTED]> > wrote: >> 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

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Jason Wong
> 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 ? *Now* I know what you're trying to do. The

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Nagasea
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" <[EMAIL PROTECTED]> > wrote: > > >>

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Jason Wong
> 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 sam

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Nagasea
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=" >FYI : posts_

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Nagasea
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=" > wrote: > > >> its not working because it's not a variable (url) >> it's a text field > >'url' is the name

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Jason Wong
> 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

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Nagasea
its not working because it's not a variable (url) it's a text field --- "Jason Wong" <[EMAIL PROTECTED]> > wrote: >> Is it possible to find and replace a data in the table using phpMyAdmin ? >> If yes, how to do that ? >> >> I want to change "http://something.com/"; to >"http://www.something.com/

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Jason Wong
> Is it possible to find and replace a data in the table using phpMyAdmin ? > If yes, how to do that ? > > I want to change "http://something.com/"; to "http://www.something.com/target"; Run an UPDATE query? UPDATE table SET url='http://something.com/' WHERE url='http://www.something.com/target

[PHP-DB] How to Replace the table data

2001-09-13 Thread Nagasea
Is it possible to find and replace a data in the table using phpMyAdmin ? If yes, how to do that ? I want to change "http://something.com/"; to "http://www.something.com/target"; thanks folks _ www.kaskus.com - FREE EMAIL SERVICE --