(strlen($post) > $maxsize ) ? substr(substr($post,0,$maxsize-1), 0,
strrpos(substr($post,0,$maxsize-1),' '))."... more" : $post;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 6:59 AM
To: [EMAIL PROTECTED]
> 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]
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->
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 is 400 characters long and I only one to show the first 50
characters and at the end showing ... dot's..
Help!
Thank you very much!
Frank
--
PHP Gener
6 matches
Mail list logo