[PHP-DB] editing part of a fiedl!
Hi, Yep the subject may sound confusing so let me explain. I have this message board that uses PHP and mysql. Now I had to transfer the whole lot to my server, but due to the change and a domain registration the actual path to images in messages has changed. So in the post on the old host it shows their file format to the image but on my server it is different. It used to use the directory board but now uses the root directory of the domain. So in the post field of the mysql it shows their message and the image code to the image and any more message. So something like this: Hi bob img src=domain.com/emotions/board/laugh.gif all is well, cya! So old posts have the wrong image location but new posts show the correct place to the image as it's configured to do it but old posts since they are already in the database show up wrong. Is there a way to edit _part_ of the post. To fix the image url. Is there a mysql query I can use to edit where board/emotions with /emotions? I am not sure if there is a way but I expect it can't be done but thought I'd ask. Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] editing part of a fiedl!
Hi, Yep the subject may sound confusing so let me explain. I have this message board that uses PHP and mysql. Now I had to transfer the whole lot to my server, but due to the change and a domain registration the actual path to images in messages has changed. So in the post on the old host it shows their file format to the image but on my server it is different. It used to use the directory board but now uses the root directory of the domain. So in the post field of the mysql it shows their message and the image code to the image and any more message. So something like this: Hi bob img src=domain.com/emotions/board/laugh.gif all is well, cya! So old posts have the wrong image location but new posts show the correct place to the image as it's configured to do it but old posts since they are already in the database show up wrong. Is there a way to edit _part_ of the post. To fix the image url. Is there a mysql query I can use to edit where board/emotions with /emotions? I am not sure if there is a way but I expect it can't be done but thought I'd ask. Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] editing part of a fiedl!
Hi, Yep the subject may sound confusing so let me explain. I have this message board that uses PHP and mysql. Now I had to transfer the whole lot to my server, but due to the change and a domain registration the actual path to images in messages has changed. So in the post on the old host it shows their file format to the image but on my server it is different. It used to use the directory board but now uses the root directory of the domain. So in the post field of the mysql it shows their message and the image code to the image and any more message. So something like this: Hi bob img src=domain.com/emotions/board/laugh.gif all is well, cya! So old posts have the wrong image location but new posts show the correct place to the image as it's configured to do it but old posts since they are already in the database show up wrong. Is there a way to edit _part_ of the post. To fix the image url. Is there a mysql query I can use to edit where board/emotions with /emotions? I am not sure if there is a way but I expect it can't be done but thought I'd ask. Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] editing part of a fiedl!
Hi, Yep the subject may sound confusing so let me explain. I have this message board that uses PHP and mysql. Now I had to transfer the whole lot to my server, but due to the change and a domain registration the actual path to images in messages has changed. So in the post on the old host it shows their file format to the image but on my server it is different. It used to use the directory board but now uses the root directory of the domain. So in the post field of the mysql it shows their message and the image code to the image and any more message. So something like this: Hi bob img src=domain.com/emotions/board/laugh.gif all is well, cya! So old posts have the wrong image location but new posts show the correct place to the image as it's configured to do it but old posts since they are already in the database show up wrong. Is there a way to edit _part_ of the post. To fix the image url. Is there a mysql query I can use to edit where board/emotions with /emotions? I am not sure if there is a way but I expect it can't be done but thought I'd ask. Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] editing part of a fiedl!
On Thursday 17 July 2003 12:28, JeRRy wrote: So something like this: Hi bob img src=domain.com/emotions/board/laugh.gif all is well, cya! So old posts have the wrong image location but new posts show the correct place to the image as it's configured to do it but old posts since they are already in the database show up wrong. Is there a way to edit _part_ of the post. To fix the image url. Is there a mysql query I can use to edit where board/emotions with /emotions? Use an UPDATE query. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* The little pieces of my life I give to you, with love, to make a quilt to keep away the cold. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php