How to retrieve all rows from an SQL table into an array?

Question

I am trying to retrieve 4 rows and I expected that It should display all 4 rows but it's only displaying the first row. This is the code I am using

$coquery = "Select distinct coName from avgcarcompany";
$crun = mysqli_query($con,$coquery);

$arrey = mysqli_fetch_assoc($crun);

print_r($arrey);

Dharman · Accepted Answer · 2020-05-30 10:23:05Z

2

If you want to get all rows from the result set then you need to fetch all. Right now you are fetching only one.

To fetch all rows use fetch_all()

$coquery = "Select distinct coName from avgcarcompany";
$crun = $con->query($coquery);

$arrey = $crun->fetch_all(MYSQLI_ASSOC)

print_r($arrey);

answered May 30, 2020 at 10:23

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

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

1 Answer 1