[SOLVED] Cutting the characters displayed (MySQL)

[JakeSilver]

Hello There!

 

I am making a small blog site for myself and instead of downloading packages i want to make it myself.

 

I am wondering if there is a way to cut the number of words displayed.. For example,

 

In blogs you usually have about 20 or 30 words displayed and then a link that says "Read More"

 

Is it the query that cuts it to 30 words? Or is it a function?

 

Can anyone shead some light on this please!

 

Many Thanks,

 

Jake

[Mchl]

You could use wordwrap() function for this

[Garethp]

$Text = Split(" ", $Text);

$Num = 30; //Number of words

$Start = 1;

$Total = "";

 

foreach ($Text as $v)

{

$Total = $Total . "" . $v . " ";

$Start = $Start + 1;

 

if($Start == $Num)

{

break;

}

}

 

it could be off by one word, in which case, adjust start to make it right

[JasonLewis]

You can do it in the query with SUBSTR, but this would do characters. Not sure if MySQL has a word limiter.

 

Or if you want you could do it like so:

 

function limit_words($text, $words){
$split = explode(" ", $text);
for($i = 0; $i < $words; $i++){
	$newText[] = $split[$i];
}

return implode(" ", $newText);
}

echo limit_words("Hello there this should be reduced to two words!", 2);

 

There is probably even a function that already does it for you. But there we are.

[JakeSilver]

ohhh Thanks guys! lots of differnt options then 

 

Problem Solved!