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-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 field
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
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
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)
5 matches
Mail list logo
