Data from MySQL changing from no data into zero

Question

I have this table of "score" in my database

!  id   !  A   ! 
-----------------
!  01   !  10  !  
!  02   !      !  
!  03   !      !  
!  04   !  5   !

$mySql = "SELECT score.id, score.A 
          FROM score
          ORDER BY score.id ASC"; 
$myQry = mysql_query($mySql, $koneksidb)  or die ("Query salah : ".mysql_error());
    while ($myData = mysql_fetch_array($myQry)) {
        $id=$myData['id'];
        $A=$myData['A'];
 }

When I call with

<?php echo $A; ?>

It came out with zero instead of no data,

!  id   !  A   ! 
-----------------
!  01   !  10  !  
!  02   !  0   !  
!  03   !  0   !  
!  04   !  5   !

What should I change?

It's the second semester of 2016 and `mysql_*` is still being used. Oh god why have you forsaken us? — Phiter, Jul 07 '16 at 11:36
Please read this. http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php If You still have a good reason to use mysql_* functions, describe it and retag question. — Michas, Jul 07 '16 at 12:54

score 0 · Accepted Answer · edited May 23 '17 at 11:58

0

Well if they are null values they will be echoed as 0.

You can do this ternary hack:

<?php echo ($A==0)?' ':$A; ?>

I didn't test, but I believe it will work. Maybe you could do that, also:

<?php echo (isset($A))?$A:' '; ?>

Also, quit using mysql_* functions, please!

edited May 23 '17 at 11:58

Community

1
1

answered Jul 07 '16 at 11:39

Phiter

14,570
14
50
84

1

@gtviga if it works you should mark this answer as accepted. Green tick near the voting buttons – Matt Jul 07 '16 at 12:46

score 0 · Answer 2 · answered Jul 07 '16 at 11:42

0

That's all right. Simplify,

$any_empty_var == false == 0

So, you can just add the condition

if ($A == 0) echo " ";
else echo $A;

answered Jul 07 '16 at 11:42

Maksim I. Kuzmin

1,170
7
16

score 0 · Answer 3 · answered Jul 07 '16 at 12:36

0

!.) You should use mysqli as mysql is obsolete. 2.) set score.A so that it can simple diplay null values

ALTER TABLE score CHANGE A INT(11) NULL; the mysql will return a null value

answered Jul 07 '16 at 12:36

Martin S.

256
1
10

Data from MySQL changing from no data into zero

3 Answers3