Echo Variable, But limit words 1

[krappleby025]

Hi all,

i have a script, which pulls a record from the database, there may be 1000 words in the field in teh database.

At the moment the script pulls the entire field and places it into the varable

$rowgetdayjob['JOB_DESCRIPTION']

Now.. what i need to do is when i echo the above i display the entire field, but the area is not big enough. i need to limit the number of words/letters that are displayed on the page..

Can anyone tell me how to do this.. Do i need to do it in the DB request. and if so what code

or can i do it and set a new variable with only the letters that have been selected..

cheers

 

[predamarcel]

hi,

you can do it with database (depends about the server).

Or you can use substr() php function:

$NN = 100 ; // number of chars
echo substr($rowgetdayjob['JOB_DESCRIPTION'], 0, $NN);

___

http://marcel.4x4.ro/

____

 

[krappleby025]

Thanks Predamarcel

That helped greatly

Cheers

 

[skiflyer]

Just in case you're interested... when I have something of that sort I prefer this code.

$max_len = 100;
if (srlen($string_to_display) > ($max_len - 3))
{
  $string_to_display=substr($str_to_display,$max_len-3);
  $string_to_display.= '...';
}

So that the user has some notification that the information was truncated.