avoid displaying empty field

[sugikrish]

hi........

I want display data from database. I done it. but some fields have null values. it display empty field . I attached screen shot with this. If you know the solution pls say to me.

[rajarajan2017]

It will be based on your requirement if you know never the category field come with values, then neglect while you writing the query and use

"select Item, Description, Rate from product"

[sugikrish]

Really thanks for quick reply. I attach one more screen shot. I used list and select the value it retrieve data from database. some fields only empty. You see attachment you get clear idea of my question.