mysqli_fetch loop not working

Question

I have a loop inside other loop which is not working, this is the code:

    while($row = mysqli_fetch_array($result))
   {
    echo "<tr>";
    echo "<td>" . $row['rowId'] . "</td>";
    echo "<td>" . $row['startDate'] . "</td>";
    echo "<td>" . $row['eventName'] . "</td>";
    echo "<td>" . $row['betName'] . "</td>";
    $string1 = "SELECT * FROM newCell WHERE rowId ='";
    $string2 = $row['rowId']."'";
    $result2 = $string1.$string2;
    echo "<td>" . $result2 . "</td>";

    while($row2 = mysqli_fetch_array($result2))
    {
        echo "<td>" . $row2['odds'] . "</td>";

        echo "<td>" . $row2['outcomeName'] . "</td>";
    }
   echo "</tr>";
   }

When I query $result2 directly into the BBDD for the first result it shows three results but the code doesn't go in the second LOOP. Why? Any error here?

You're asking it to loop through a `string`, not an `mysqli` object? — MackieeE, Sep 26 '13 at 12:32
`mysqli_fetch_array` works on query result not on query string — bansi, Sep 26 '13 at 12:33

score 0 · Answer 1 · answered Sep 26 '13 at 12:34

0

Use:

$query = "SELECT ....";
$result2 = mysqli_query($db, $query);

while($row2 = mysqli_fetch_array($result2))
{
        echo "<td>" . $row2['odds'] . "</td>";

        echo "<td>" . $row2['outcomeName'] . "</td>";
}

answered Sep 26 '13 at 12:34

q0re

1,401
19
32

score 0 · Answer 2 · edited Sep 26 '13 at 12:58

0

I think $result2 should be output of mysqli_query not just merely query. Talking in analogous to MySQL.

Probably you should have something like this

$result2 = mysqli_query($result2);

edited Sep 26 '13 at 12:58

Joshua Taylor

84,998
9
154
353

answered Sep 26 '13 at 12:35

Amit Gupta

533
6
17

score 0 · Answer 3 · edited May 23 '17 at 12:22

0

Before read this How can I prevent SQL injection in PHP? topic. After try to use mysql_query()

edited May 23 '17 at 12:22

Community

1
1

answered Sep 26 '13 at 12:35

RDK

4,540
2
20
29

score 0 · Answer 4 · answered Sep 26 '13 at 12:35

Try This

<?php
while($row = mysqli_fetch_array($result))
   {
    echo "<tr>";
    echo "<td>" . $row['rowId'] . "</td>";
    echo "<td>" . $row['startDate'] . "</td>";
    echo "<td>" . $row['eventName'] . "</td>";
    echo "<td>" . $row['betName'] . "</td>";
    $string1 = "SELECT * FROM newCell WHERE rowId ='";
    $string2 = $row['rowId']."'";
    $result2 = $string1.$string2;
    echo "<td>" . $result2 . "</td>";
    $results = mysqli_query($db,$result2);
    while($row2 = mysqli_fetch_array($results))
    {
        echo "<td>" . $row2['odds'] . "</td>";

        echo "<td>" . $row['outcomeName'] . "</td>";
    }
   echo "</tr>";
   }
  ?>

score 0 · Accepted Answer · answered Sep 26 '13 at 12:38

  while($row = mysqli_fetch_array($result))
   {
    echo "<tr>";
    echo "<td>" . $row['rowId'] . "</td>";
    echo "<td>" . $row['startDate'] . "</td>";
    echo "<td>" . $row['eventName'] . "</td>";
    echo "<td>" . $row['betName'] . "</td>";
    $string1 = "SELECT * FROM newCell WHERE rowId ='";
    $string2 = $row['rowId']."'";
    $result2 = $string1.$string2;
    echo "<td>" . $result2 . "</td>";

    $result2 = mysqli_query($connection, $result2);

    while($row2 = mysqli_fetch_array($result2))
    {
        echo "<td>" . $row2['odds'] . "</td>";

        echo "<td>" . $row2['outcomeName'] . "</td>";
    }
   echo "</tr>";
   }

score 0 · Answer 6 · answered Sep 26 '13 at 12:43

0

Before fetching data execute mysql query using mysqli_query() function then run mysqli_fetch_array(). It would be good if you count result as $count = mysqli_num_rows($query) and manage your code with if... else .

answered Sep 26 '13 at 12:43

Praveen D

2,337
2
31
43

mysqli_fetch loop not working

6 Answers6