Php Word Count Limit

[ryanwood4]

Hi,

 

I can't figure out how to limit the word count fetched from the database.

 

I simply want to show 10 words from the 'body' column.

 

I'm using the below echo code to display the information.

 

  echo '<div class="menu"><div class="item">';
  echo '<h1><a href="news/display/'.$row['id'].'">'.$row['title'].'</a></h1>';
  echo '<img src="../'.$row['image'].'"/>';
  echo '<p>'.$row['body'].'</p>';
  echo '</div></div>';

 

Any help is appreciated.

 

Thanks.

[Pikachu2000]

I'd be inclined to limit it in the query itself, using SUBSTRING_INDEX().

Edited November 11, 2012 by Pikachu2000

[Andy123]

You can limit the result set that you get back from your database by using MySQL's LIMIT clause.

 

SELECT * FROM MyTable LIMIT 0, 10

 

Edit: I misunderstood the question; I thought each row had one word and didn't realize that all of the words are in the same column.

Edited November 11, 2012 by Andy123

[ryanwood4]

I'd be inclined to limit it in the query itself, using SUBSTRING_INDEX().

 

Never used this before. How would that be implemented?

 

Here's my code. I'm guessing it would go within the mysql_query?

 

<?php
$con = mysql_connect("localhost","XXX","XXX");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("XXX", $con);

$result = mysql_query("SELECT * FROM `articles` WHERE `id` NOT LIKE '%$id%' and `category` NOT LIKE '%paddock%' ORDER BY `date` DESC LIMIT 0,10");

while($row = mysql_fetch_array($result))
{
echo '<div class="menu"><div class="item">';
echo '<h1><a href="news/display/'.$row['id'].'">'.$row['title'].'</a></h1>';
echo '<img src="../../'.$row['image'].'"/>';
echo '<p>'.$row['body'].'</p>';

echo '</div></div>';
}

mysql_close($con);
?>

Edited November 11, 2012 by ryanwood4

[PFMaBiSmAd]

Pika's reply contains a link to the mysql documentation for that function. There's an example at that link.