This add a bit more functionality, in that it will adjust to the nearest end
of a word, and includes a 'more' link to the full text. This also assumes
that the article may already only be 50 chars or less.
$maxsize = 50; // might be better as a DEFINE
$post = $row->text;
$post = (strlen($post) >
> Make it with your sql query, it will be faster:
> SELECT ..., IF(LENGTH(text)>50, CONCAT(SUBSTRING(text,0,50),'...'),
> text) as text
I won't outright disagree, but warn fkessen to be careful. There are
some scenarios in which that would not be faster.
-Dan
--
PHP General Mailing List (htt
Make it with your sql query, it will be faster:
SELECT ..., IF(LENGTH(text)>50, CONCAT(SUBSTRING(text,0,50),'...'),
text) as text
[EMAIL PROTECTED] wrote:
Hi there,
Hope you can help me with the following:
I have a query and i'm showing the output:
echo $row->text;
That goes o.k. but the text
Try this:
if(strlen($row->text)>50) {
echo substr($row->text,0,47) . "...";
} else {
echo $row->text;
}
- Audun
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 3:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Limit output of query
Look up the function substr. It will allow you to create a string of
the first 50 chars from your 400 char string.
-Dan
On Sat, 2003-07-05 at 09:58, [EMAIL PROTECTED] wrote:
> Hi there,
>
> Hope you can help me with the following:
>
> I have a query and i'm showing the output:
>
> echo $row->
5 matches
Mail list logo
