Re: remove last comma in string
| From: | Chris | Date: | Fri, 09 Jun 2006 01:10:59 +0000 |
| Subject: | Re: remove last comma in string | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-237656@lists.php.net to get a copy of this message | ||
weetat wrote:
Hi all, I am using php 4.3.2 and mysql , linux. I have a sql statement below :How about: $query = substr(trim($query), 0, -1); ? -- Postgresql & php tutorials http://www.designmagick.com/UPDATE tbl_chassis_temp SET country = 'Singapore', city 'SINGAPORE', building = 'Tampines Central 6', other = 'Level 03-40',I need to remove the last comma from sql text above. I have tried using substr and rtrim , without any success ? Anyone have any suggestion ?