mysql select query only showing one data in php

Question

so I'm trying to show data from my sql table. There are two data but only one of them shows when I try to open my php page. here's my codes :

<?php
    include ("koneksi.php");

    // $username=$_GET['username'];
    $username="Dia";

    $result = mysql_query("SELECT * FROM tbl_penyakit_user WHERE username='Dia'");
    $row = mysql_fetch_array( $result );

    echo " penyakit: ".$row['penyakit'];

?>

I tried to run the select query on phpmyadmin an it showed 2 data. Thanks in advance

You need to fetch the second row - this is typically done in a loop — Eugen Rieck, May 01 '14 at 14:56
Also you could consider looking into PDO in PHP. One of my personal favorites when working wih databases. — Josef E., May 01 '14 at 15:21

score 3 · Accepted Answer · edited May 23 '17 at 10:28

3

mysql_fetch_array only gets one array at a time. To properly get all available rows, put it in a while-loop like so:

while($row = mysql_fetch_array($result)) {
    echo " penyakit: " . $row['penyakit'];
}

As an aside, however, please note that the mysql_* functions are considered deprecated, and should not be used in future development. (Here's why)

edited May 23 '17 at 10:28

Community

1
1

answered May 01 '14 at 14:56

Chris Forrence

10,042
11
48
64

score 1 · Answer 2 · edited May 01 '14 at 15:03

1

You have to use while loop while more than one row.

<?php
    include ("koneksi.php");
    // $username=$_GET['username'];
    $username="Dia";

    $result = mysql_query("SELECT * FROM tbl_penyakit_user WHERE username='Dia'");
    while($row = mysql_fetch_array( $result ))
    {
        echo " penyakit: ".$row['penyakit'];
    }
?>

edited May 01 '14 at 15:03

Chris Forrence

10,042
11
48
64

answered May 01 '14 at 14:57

Chirag Shah

1,463
2
18
40

score 1 · Answer 3 · answered May 01 '14 at 14:57

1

Try this:

$result = mysqli_query($con,"SELECT * tbl_penyakit_user WHERE username='Dia'");

    while($row = mysqli_fetch_array($result)) {
      echo $row['penyakit'];
    }

Hope this helps!

answered May 01 '14 at 14:57

Josef E.

2,179
4
15
30

score 1 · Answer 4 · answered May 01 '14 at 14:57

    <?php
 include ("koneksi.php");

// $username=$_GET['username'];
 $username="Dia";

 $result = mysql_query("SELECT * FROM tbl_penyakit_user WHERE username='Dia'");
 while($row = mysql_fetch_assoc( $result )){
     echo " penyakit: ".$row['penyakit'];
}

        ?>

score 1 · Answer 5 · answered May 01 '14 at 14:57

1

You need to fetch each row so use a while loop

while ($row = mysql_fetch_array( $result )) {
    echo " penyakit: ".$row['penyakit'];
}

This should output all rows, you only fetch one.

answered May 01 '14 at 14:57

dops

800
9
17

mysql select query only showing one data in php

5 Answers5