i am selecting data from database but when i echo it, i found that the data is too long
all that i need is to divide the returned data into two parts.
i used the function

PHP Code:

substr($tr_res["bio"], 0, 210) 


but it cut the data.. for exmaple : this is john Zakaria Sabry
it returns
this is jo
hn Zakaria Sabry

i want to make a variable ($var) that stops on the first </br> tag and count the number of character from the first letter until it reaches the first </br>

after that i will put the $var into my code

PHP Code:

substr($tr_res["bio"], 0, $var) 


can anyone help me plz

It's going to depend on exactly what the <br> tag looks like (it won't be </br>); In XHTML, BR is <br />, otherwise it will be <br>.

The key is the explode() function:

PHP Code:

$chunk = explode("<br />", $tr_res["bio"]);
$substr = substr($chunk[0], 0, 120);