在MySQL查询结果中检测EOF

Question

I've a MySQL database and one of the columns is 'Address' which sometimes contains more then 1 row. For instance I have the following address:

Street X, Block Y, Apartment Z, Door W

When I will get data from MySQL and echo it I'd end up with:

Street X, Block Y, Apartment Z, Door W

How do I detect the end of row in MySQL so I can add a . <br> ?

Answer 1

Use nl2br function, which has following the description:

Inserts HTML line breaks before all newlines in a string

So finally the code to do your task will be as simple as

$address = nl2br($address);