PROS! Getting rid of...(easy)

[brianb]

hello pros,

I have a simple question...

I have entries automatically going into a certain field in my MySQL database seperated by commas. Like so:

$field = first, second, thrid, fourth,

Now, See that comma after the last word? I'd lie to get rid of that before it enters my database.

Is there an easy way to strip this last comma?

Please help. Every coding example is appreciated!

Thanks.

[pipeten]

If "," is always the last character
$rest = substr("abcdef,", 0, -1); // returns "abcdef"

[pipeten]

you could also do it with mysql
INSERT INTO table (foo,barr) VALUES ('$foo',SUBSTRING('a,b,c,',-1))

you would have double check that in the mysql mans. Also I think it is mysql version specific.

[brianb]

yeah... "," is always the last character...the PHP version should work fine! Thanks!