Trim a content from database?

Question

I am calling all names from a mysql database using php. Some names are very large. so i want to show first 7 charectors and put "..."

Here is my code:

<?php $result = mysql_query("SELECT * FROM Persons WHERE section='one' ORDER BY FirstName");
while($row = mysql_fetch_array($result))
{
    $fst = $row['FirstName']; ?>

Any suggestions please?

do want something like this (johnseb...)? – geovani075 Jun 01 '13 at 11:34 — geovani075, Jun 01 '13 at 11:34

score 2 · Answer 1 · answered Jun 01 '13 at 11:34

2

Try like

if(strlen($row['FirstName']) > 7)
     $fst = substr($row['FirstName'],0,7).'....';

answered Jun 01 '13 at 11:34

GautamD31

28,552
10
64
85

1

That will cut from the 7th character forward... – Christian Jun 01 '13 at 11:37
Try it now...I didnt understand whether he need from 7th char or after 7th char – GautamD31 Jun 01 '13 at 11:38
He said first 7 chars...So mine will work – GautamD31 Jun 01 '13 at 11:39
1

Now that you changed it, sure it will work. – Christian Jun 01 '13 at 11:40
And for the record, there's something called `…`. – Christian Jun 01 '13 at 11:40

score 1 · Accepted Answer · answered Jun 01 '13 at 11:36

1

try this:

if (strlen($fst) <7) {
    echo $fst;
    } 

else{
    echo substr($fst,0,7); echo "..."; 
    }

answered Jun 01 '13 at 11:36

geovani075

369
1
2
12

Trim a content from database?

2 Answers2