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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
