Re: How to Replace the table data
| From: | Jason Wong | Date: | Fri, 14 Sep 2001 04:27:43 +0000 |
| Subject: | Re: How to Replace the table data | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12434@lists.php.net to get a copy of this message | ||
> 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