RE: [PHP] Limit output of query field

2003-07-05 Thread Giz
(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]

Re: [PHP] Limit output of query field

2003-07-05 Thread Dan Anderson
> 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

Re: [PHP] Limit output of query field

2003-07-05 Thread Marek Kilimajer
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

RE: [PHP] Limit output of query field

2003-07-05 Thread Audun Larsen
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]

Re: [PHP] Limit output of query field

2003-07-05 Thread Dan Anderson
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->

[PHP] Limit output of query field

2003-07-05 Thread fkeessen
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