Can someone tell me, how to get first 5 characters from the some word i have i my database (mysql) example: $word = VerylongLonglognword_or_sentence; $short_w= veryl...;

Reply

I'm going to use the variables that you've used. Say your $word contains the very long word. Now:



This should extract the first 5 characters from your $word and store it in $short_w. This is assuming you are using PHP with MySQL. If you want a little more explanatin - the substr function extracts a substring from your string based on the parameters provided to it. General form is: susbstr ( LargeString, StartPosition, LengthOfSubString ) - this extracts a string of length LengthOfSubString starting at position StartPosition from your original string LargeString.

Hope this helps.

 

 

 

Reply

tnx, its working!

Reply

You can also use $variable[length], eg. $variable[4]. Remember that the starting position is 0, not 1, so this would extract the first 5 characters.

Reply

Argh, what am I thinking? That would select the character, not the first 5 characters. It's 3:00am, so you'll have to excuse my incoherence.

Reply