How to rid of extra white space?

I have a textbox that i use nl2br to insert into db. The problem is that 开发者_运维问答

is adding too much space. Is there a way to assign this an id while being processed or some other way to reduce the space between sentences?

---

Looks like what you want is some cleanups of those lines. This is what I use on my php apps.

<?php
function trimlines($html){
    $ret = str_replace("\r\n","\n",$html);
    $ret = explode("\n",$ret);
    $ret = array_map('trim',$ret);
    $ret = join("\r\n",$ret);
    return $ret;
}
?>

Regular expressions can also be used, but for quick cleanups, this works well for me. Hope it helps :)

---

I would suggest wrapping the variable in sql with TRIM('sentences here')