30 chars only

CMS output

[FnTm]

Hi!

So what I would like to have, is a script that outputs only 30chars from a database field, that contains more than 300.

It is for my newest articles list on my cms. Can it be done?
Can I output only 30 or less chars?

[Habtom]

substr

SELECT substr(text_long,0,30) AS text_short
FROM text_pool

Habtom

[edited by: Habtom at 7:44 am (utc) on Aug. 13, 2007]

[FnTm]

Yeah, i think it would work, but i am using * to output my results...

$result = mysql_query("SELECT * FROM cms ORDER BY id desc limit 5");

can I incorporate that command in here too?
[edit] it follows with these commands:
while($row = mysql_fetch_array($result))
echo "<td><br><font class=\"text\">".$row['title'] . ";

[edited by: FnTm at 8:03 am (utc) on Aug. 13, 2007]

[Gian04]

I think much better to use this one

echo mb_strimwidth($row['title'], 0, 30, "...");

[dreamcatcher]

echo "<td><br><font class=\"text\">".(strlen [php.net]($row['title'])>300? substr [php.net]($row['title'],0,30) : $row['title']).";

dc

[Habtom]

$result = mysql_query("SELECT * FROM cms ORDER BY id desc limit 5");

> The easiest thing to do is to change * to the field names you have. Anyway, you are better off having the field names instead for several reasons.

If you want to keep it that way, you can use the substr function in PHP code itself.

$title = substr($title, 0, 30);

Habtom

[FnTm]

Thanks Habtom! really helped alot!