mysql query does not showing multiple rows

Question

my database sample is like this

database:test
table:test

id  name  password   message  active
1   test  testpass   testmsg   no
2   test2 testtest   testmsg2  no

and when i run sql query and show it in php it just gives one result. php part was,

$a=mysqli_query($con,"select name from test where active='no'");
$b=mysqli_fetch_array($a);
print_r($b);

and it showed only the first record

test

can anybody please suggest me,where I am doing wrong?

bugwheels94 · Accepted Answer · 2013-06-26 09:18:40Z

2

Use a while loop to iterate over all the records

$a=mysqli_query($con,"select name from test where active='no'");
while($b=mysqli_fetch_array($a))
print_r($b);

answered Jun 26, 2013 at 9:18

bugwheels94

32.1k3 gold badges43 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rr- · Accepted Answer · 2013-06-26 09:19:43Z

2

This is desired behavior of PHP. You should fetch the rows in loop, like this:

$result = mysqli_query($con,"select name from test where active='no'");
while ($row = mysqli_fetch_array($result))
{
    print_r($row);
}

answered Jun 26, 2013 at 9:19

rr-

14.9k6 gold badges49 silver badges68 bronze badges

Daniel Robertus · Accepted Answer · 2013-06-26 09:18:42Z

0

try this:

echo "<pre>";
print_r($b);
echo "</pre>";

answered Jun 26, 2013 at 9:18

Daniel Robertus

1,1021 gold badge11 silver badges25 bronze badges

Rohitashv Singhal · Accepted Answer · 2013-06-26 09:25:52Z

0

You have to fetch the result using loop :

$b = mysql_fetch_array($query)

foreach($b as $b)
{
  echo $b[];
]

answered Jun 26, 2013 at 9:25

Rohitashv Singhal

4,56713 gold badges63 silver badges107 bronze badges