trim output from database

Can anyone help with how to limit the amount of text displayed on a page after a query from a db.

if the result is :

cdr media from sony in a box of 10

i want to show

cdr media from sony

Thanks

You can use
print substr($row["fieldfromdb"], 0 15);

Or you can just select the substring you want from the database.

SELECT LEFT(fieldfromdb,15) FROM your_table

then use $row[fieldfromdb] and it'll only be 15 characters...

---John Holmes...

Either way works, what if you want to re-use the string somewhere else?

sorry, but how do i use that with a url ?

The code i have so far

while($myrow = mysql_fetch_array($result))
{

$QuesID = $myrow["QuestionID"];
$Question = $myrow["Question"];

echo "<li>";
echo "<a href=\"viewquestion.php?QuestionID=$QuesID\">$Question</a>";

I am trying to trim the $Question output

Thanks

Well if you use John's example you could jus tdo the way you are doing for mine:
$Question = substr($myrow["Question"], 0, 15);

Either way will work depending on your needs

Thanks louie and John, got that working now