how to fetch multiple rows with same field value from a mysql database using php

Question

|touser| fromuser |  msg  |
|  A   |    B     | hi    |
|  A   |    B     | hello |
|  C   |    D     | bye   |
|  C   |    E     | hey   |

when i use following query in mysql workbench it shows the desired result that is all the rows with given name:

select * from db.table1 where touser in ('A');

output:

|touser| fromuser |  msg  |
|  A   |    B     | hi    |
|  A   |    B     | hello |

but when i pass query from php commands the resultant array contains only first record

<?php
 //connection establishing commands
 $sql="select * from db.table1 where touser in ('A')";

 $result=mysqli_query($link, $sql);

 $data=mysqli_fetch_array($result,MYSQLI_NUM);

 print_r($data);

 //other stuff;
 ?>

output:

    Array ( [0] => A [1] => B [2] => Hi )

am I missing something in the php commands?

dont use mysqli functions now...it is not recommanded nowadays... — Shwet
– Shwet, Commented Sep 19, 2013 at 19:27

nathangiesbrecht · Accepted Answer · 2013-09-19 18:56:19Z

2

You're PHP is simply returning the first row of the MySQL result set.

You'll want to replace $data=mysqli_fetch_array($result,MYSQLI_NUM);

with

while ($data = mysqli_fetch_array($result, MYSQLI_NUM)) {
    print_r($data);
}

Which will iterate over each row of the result set. In other words, the mysqli_fetch_array function doesn't fetch the entire result set as an array, it simply returns a single row, and then moves the row "pointer" to the next row.

answered Sep 19, 2013 at 18:56

nathangiesbrecht

98014 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

how to fetch multiple rows with same field value from a mysql database using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related