empty strings in mysql

[Anon]

I have a table with 5 fields for company address line 1, 2, 3, 4, 5. If i have an address that by chance only has 4 lines in it, how do i get PHP to handle the empty string?

At present im calling the result from the select query and parsing it with php to show all 5 lines, say addline4 is empty, when presented it leaves a gap between line3 and 5....

regards
oli

[Anon]

You could use empty() to check if a string is empty then not print it.

[Anon]

Have u got example code?

Thanx
oli