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 =
weetat wrote:
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 ?
On Fri, June 9, 2006 5:17 pm, Paul Novitski wrote:
rtrim() won't work, as ',' is not whitespace.
Richard, you're wrong -- read the manual. All three functions
trim(), ltrim(), and rtrim() allow you to append an optional list of
characters to be trimmed:
http://php.net/trim
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
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
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
6 matches
Mail list logo