1st 5 Chars 1st 5 chars from the word

[iGuest 3]

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

[miCRoSCoPiC^eaRthLinG 0]

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...;

58012[/snapback]

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

 

$short_w = substr ( $word, 0, 5 );

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.

[iGuest 3]

tnx, its working!

[Spectre 0]

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.

[Spectre 0]

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.