displaying only apart of a string 4

[Roberti]

Hi all,

I have a memo field in a mysql database and I only want to display the first 40 characters on my page, how do I do that?

Greeting, Roberti

 

[vbkris]

$str=ROW_VALUE_HERE

echo substr($str,0,40);?

Known is handfull, Unknown is worldfull

 

[onpnt]

http://www.php.net/manual/en/function.substr.php

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[welshtroll]

or you could only read 40 characters in the sql statement

LEFT(str,len)
Returns the leftmost len characters from the string str

SELECT LEFT('foobarbar', 5)
would return 'fooba'

Worth a thought

'... and then it wouldn't compile?'

 

[Roberti]

Thanx all, it works perfectly.

Greetings, Roberti