# Display blank field in table instead of "0"?

**URL:** <https://forum.kirupa.com/t/display-blank-field-in-table-instead-of-0/284018>\
**Category:** programming\
**Created:** [March 13, 2009, 7:44pm UTC](https://forum.kirupa.com/t/display-blank-field-in-table-instead-of-0/284018 "2009-03-13T19:44:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![eyebum](https://avatars.discourse-cdn.com/v4/letter/e/e495f1/32.png) [@eyebum](https://forum.kirupa.com/u/eyebum)\
**Post date:** [March 13, 2009, 7:44pm UTC](https://forum.kirupa.com/t/display-blank-field-in-table-instead-of-0/284018/1 "2009-03-13T19:44:13Z")

</div>

Hey there,  
I am using mysql and php 5.  
I have a lot of score data to display in tables. they are results from competitions. In these results, a Zero (‘0’) is different than no score.  
I have the score fields set as decimal, as they are added and such. When I display the results, any fields that have no score default to displaying a ‘0’. I would like them to display nothing (blank) or a hyphen (-).  
Has anyone encountered a way to do this with decimal or integer fields?

Thanks,

Chris