How can an SQL query return data from multiple rows

Question

<?php
$con = mysqli_connect("localhost","root","","register");
$sql = "SELECT * FROM photos WHERE user_id ='$id'";
$result = mysqli_query($con,$sql);
$array = mysqli_fetch_assoc($result);
$rowcount = mysqli_num_rows($result);
$source  = $array['photo'];
?>

I want to get data from colomn photo, but if I have several rows with the same user_id, $source = $array['photo'] returns me data only from first row. How can i get data from all rows with same user_id??

and my DB is:

+----+---------+----------+
| id | user_id | photo    |
+----+---------+----------+
|  1 |    14   | 1010.jpg |
|  2 |    14   | 1013.jpg |
|  3 |    14   | 1210.jpg |
|  4 |    10   | 1173.jpg |
|  5 |    20   | 2038.jpg |
+----+---------+----------+

Using while. It's written in all manuals.

u_mulder
– u_mulder

2017-05-28 16:23:42 +00:00
Commented May 28, 2017 at 16:23 — u_mulder
– u_mulder, Commented May 28, 2017 at 16:23

PeterMader · Accepted Answer · 2017-05-28 16:25:38Z

1

<?php
$con = mysqli_connect("localhost","root","","register");
$sql = "SELECT * FROM photos WHERE user_id ='$id'";
$result = mysqli_query($con,$sql);
$rowcount = mysqli_num_rows($result);

while ($row = mysqli_fetch_assoc($result)) {
  $source = $row['photo];
  // do stuff with $source
}
?>

Take a look at the docs about mysqli_fetch_assoc.

answered May 28, 2017 at 16:25

PeterMader

7,3352 gold badges24 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How can an SQL query return data from multiple rows

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