Restricting how many words/charcters are shown

ld0121

Hi all, I am putting together a kind of portal homepage, I have the script that will pull out and display information at random but the information can range from 10 words to 100 words. Is there a way of coding the php to just show the first 10 words from the database entry or another way show the first 100 characters of the database entry, obviously this will then help me greatly with the design.

Heres the snippit of code that displays the infomation....

echo "$info " ;

Any help would be great.

Thanks
Lee

fikse

$info = substr("$info", 0, 100);

ld0121

Hi, thanks for the reply.... i know im probably being thick but how does that fit in to the code....

$query = "SELECT * FROM gzdata1 ORDER by rand() LIMIT 0, 1;";

$numresults=mysql_query($query);

// get results
$result = mysql_query($query) or die("X Couldn't execute query");

// begin to show results set
$count = 1 + $s ;

//display the results returned
while ($row= mysql_fetch_array($result)) {
$url = $row["url"];
$name = $row["name"];
$info = $row["info"];
$town = $row["town"];
$simg = $row["simg"];

echo "$simg" ;
echo "$name $town" ;
echo "$info " ;
echo "<a href=\"" . $row["url"] . "\" target=\"_blank\">Visit the website</a>";
$count++ ;
}

fikse

anywhere after $info = $row["info"]; and before you echo it out to the browser....

or you can change:

$info = $row["info"];

$info = substr($row["info"],0,100);

ld0121

Thats sorted it, thanks for your help.

Weedpacket

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10222958&highlight=limiting+number+of+words
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10222701&highlight=limiting+number+of+words
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10211902&highlight=limiting+number+of+words