how to..

[aprinc]

when printing data on the screen from database field show only 20 first characters. Lets say that DB field have contain 50 characters and I want to show only first 20 characters.

Thanks in advance

[aprinc]

Have found a solution, so there is no need for reply 🙂

[dj4uk]

What was the solution?

[aprinc]

$query = "select (LEFT(FIELD_NAME_HERE,20)) from TABLE_NAME";

[dj4uk]

Excellent thank you!