question about int fields

[graham23s]

Hi Guys,

 

i have a few fields in mysql that are purely numbers (int) if a user hasn't filled in a fields the default value is 0 (and also echoes out 0) is there anyway i can have it not echo anything out untill the proper value is filled in? or would i need to set it to varchar?

 

thanks guys

 

Graham

[BillyBoB]

try when you echo it out on your php:

 

<?php
if($array[intfield]==0) {
  echo ("Not filled");
}else{
  echo $array[intfield];
}
?>

[graham23s]

Thanks BB ,

 

will try that:)

 

Graham