Re: remove last comma in string
| From: | Richard Lynch | Date: | Fri, 09 Jun 2006 22:00:14 +0000 |
| Subject: | Re: remove last comma in string | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-237715@lists.php.net to get a copy of this message | ||
You're missing an = for the city.
substr() should have worked.
rtrim() won't work, as ',' is not whitespace.
On Thu, June 8, 2006 7:58 pm, weetat wrote:
> Hi all,
>
> I am using php 4.3.2 and mysql , linux.
>
> I have a sql statement below :
>
> 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 ?
>
> THanks
> - weetat
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Like Music?
http://l-i-e.com/artists.htm