Shortening a fetched array

[ViperBlade]

Hi, i'm unsure of the versions of MySQL and PHP I'm using (although my webhost 'guarantees' the latest), but I don't think the answer would vary that much between versions.
Now to the point:
I'm trying to echo text fetched from a database into a 128px width column, which doens't always fit. I'd like to know how to shorten the results of an array using '...'s like: 'Amer...' or 'Urag...' instead of 'America' or 'Uraguay'.

Thank you,
ViperBlade

[Motoma]

Hi, i'm unsure of the versions of MySQL and PHP I'm using (although my webhost 'guarantees' the latest), but I don't think the answer would vary that much between versions.
Now to the point:
I'm trying to echo text fetched from a database into a 128px width column, which doens't always fit. I'd like to know how to shorten the results of an array using '...'s like: 'Amer...' or 'Urag...' instead of 'America' or 'Uraguay'.

Thank you,
ViperBlade

Welcome to theScripts ViperBlade!
This task will be quite difficult unless you are using a monospaced font.

[ViperBlade]

Welcome to theScripts ViperBlade!
This task will be quite difficult unless you are using a monospaced font.

True, but i'll be using Lucidia Sans Console. Do you have any ideas? I know it's
possible because phpMyAdmin shortens certain fields with '...'s.

Thanks for the welcome,
ViperBlade

[Motoma]

True, but i'll be using Lucidia Sans Console. Do you have any ideas? I know it's
possible because phpMyAdmin shortens certain fields with '...'s.

Thanks for the welcome,
ViperBlade

In order to fit it correctly inside a certain pixel width, you would have to calculate the width of each character, and the truncate the string, and append "..."