Limit string output size from a database record 1

[martinb7]

Hi, how would you go about limiting the output string size from a record??

Say i have a string of

Welcome to WebRevolt, the Next Web Revolution, how could i limit that to a 100 characters then add '... more' after it??

its for my news poster so I dont have massive news articles on the homepage

any ideas

thanx


Martin

Computing help and info:

http://www.webrevolt.biz

 

[Chacalinc]

SELECT CONCAT(SUBSTRING(field_title,1,100),'...') FROM news_table where ID=new_id_to_search

Hope this helps.

http://dev.mysql.com/doc/mysql/en/String_functions.html

 

[martinb7]

yea but i would like to do it in, php code, not SQL, do you know the othr way as well??

thanx

Martin

Computing help and info:

http://www.webrevolt.biz

 

[Chacalinc]

<?php

$sql="SELECT CONCAT(SUBSTRING(field_title,1,100),'...') FROM news_table where ID=new_id_to_search";
$qry=mysql_query($sql) or die (mysql_error());
..

 

[Chacalinc]

or using only php:

<?php

echo substr($field_news,1,100) . "...";

 

[martinb7]

thanks, worked a treat

Martin

Computing help and info:

http://www.webrevolt.biz