Print multiple rows array in php

Question

I have a query which could return multiple rows.

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
    $data[] = $row;
    foreach ($data as $row){
       echo $row['...'];
    }
}

The problem is that it only prints one row, while i should have 2 rows printed.

Could someone help me out?

it will print all the rows, are you sure the query doesn't return a single row? — RageZ
– RageZ, Commented Dec 23, 2011 at 9:28
I have entered the query in PhpMyAdmin it does return 2 rows. But when i print the value's i only get 1 row.. — Sino
– Sino, Commented Dec 23, 2011 at 9:30
It looks like it should print duplicates actually... Like it would print 3 rows if 2 were returned, and then 6 if 3 were returned. (Unless $data is being reset.) — Corbin
– Corbin, Commented Dec 23, 2011 at 9:41

JJJ · Accepted Answer · 2011-12-23 09:31:05Z

2

The problem is probably that you're re-using the $row variable. Also, the logic is a bit strange: why are you looping through $data every time you fetch a new row? Did you mean to do this instead:

while ($row = mysql_fetch_array($result)){
    $data[] = $row;
}

foreach ($data as $row){
   echo $row['...'];
}

answered Dec 23, 2011 at 9:31

JJJ

33.2k20 gold badges95 silver badges103 bronze badges

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

4 Comments

RageZ Over a year ago

plus the reuse of row shouldn't be a problem.

Michael Over a year ago

I think he wants to iterate over the columns - thats why the foreach was inside the while loop

Sino Over a year ago

Juhana, thanks.. I have noticed my fault haha.. This did the job! Thanks everybody.(Will accept answer when i can.)

JJJ Over a year ago

@RageZ @Michael Right, but on the second pass of the while loop he adds another record on $data and does the foreach loop again from the beginning. If there are say 3 results, he'll first display $data[0], then $data[0] and $data[1], and again $data[0], $data[1] and $data[2].

Michael · Accepted Answer · 2011-12-23 09:31:11Z

0

Try something like:

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
    foreach ($row as $k=>$v){
       echo $k ." = " . $v;
    }
}

answered Dec 23, 2011 at 9:31

Michael

1,8867 gold badges22 silver badges35 bronze badges

Comments

Dau · Accepted Answer · 2011-12-23 09:31:22Z

0

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
    $data[] = $row;
    foreach ($data as $col){
       echo $col['...'];
    }
    echo '<br>';
}

OR

echo '<table>';
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
    $data[] = $row;
    echo '<tr>';
    foreach ($data as $col){
        echo '<td>';
       echo $col['...'];
       echo '</td>';
    }
    echo '</tr>';
}
echo '</table'>;

answered Dec 23, 2011 at 9:31

Dau

8,9204 gold badges25 silver badges49 bronze badges

Comments

khael · Accepted Answer · 2011-12-23 09:32:05Z

0

Maybe the problem is that you iterate the $data array in side the while loop, I think you want to collect all the rows in the $data, and only when while breaks to iterate it to show the results.

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
    $data[] = $row;

}
foreach ($data as $row){
       echo $row['...'];
    }

Or did I misunderstood?

answered Dec 23, 2011 at 9:32

khael

2,6101 gold badge18 silver badges36 bronze badges

Comments

score 0 · Accepted Answer · 2011-12-23 09:39:29Z

0

    Do some changes in your code for check no. of results

$result = mysql_query($query);



    while ($row = mysql_fetch_array($result)){

        foreach ($row as $val){
           echo $val;
        }
    }

edited Dec 23, 2011 at 9:39

answered Dec 23, 2011 at 9:32

user319198

3 Comments

Michael Over a year ago

what's the point of checking how many rows as returned? And why would you only want to enter the loop if it was 1?

user319198 Over a year ago

Might be query returning single row.

Michael Over a year ago

That wouldn't matter, the while loop will still enter when 1 row is returned

Collectives™ on Stack Overflow

Print multiple rows array in php

5 Answers 5

4 Comments

Comments

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related