redtrive data from MYSQL DB

[sujith787]

in my mysql DB. i have a table.
in that table a field having around 1500 charecter.
i get that data by using php echo.

now i want to display only first 25 charecters.

same time iam displaying the retrived data in a table cell. if i get the full data that distrub make the table alignment.

is there any way to make the table table standard. and is there any way to avoid the extra datas which destroy the table structure and display only the portion of a data which dont distrub the table structure..

[sujith787]

anybody there to help me

[sujith787]

plz help

[thetestingsite]

You could probably use substr() (http://www.php.net/substr) to limit the number of characters from the db to whatever you want. If you need help adding this to your php script, post the script and I'll have a stab at it.

Hope this helps.