CODEWITHSUNDEEP
phpmysqlmysqli
altaire lastname
altaire lastname

Reputation: 21

How to stop the looping statement?

I'm trying to create a table number for each item in my database records, but i don't know how to stop the looping.

How can I stop it? Below is my codes. Help?

while($row = $result->fetch_assoc()){
    for ($i = 1; $i < $row; $i++ ) { 
        echo'<tr>
                <td>'.$i.'</td>
                <td>'.$row['supplier'].'</td>
                <td>'.$row['item_name'].'</td>
                <td>'.$row['item_description'].'</td>
                <td>'.$row['quantity'].'</td>
                <td>'.$row['unit'].'</td>
                <td>'.number_format($row['unit_cost'], 2, '.', ',').'</td>
                <td>'.number_format($row['total_amount'], 2, '.', ',').'</td>
            </tr>';
           }
           }

Upvotes: 0

Views: 65

Answers (3)

tyko
tyko

Reputation: 96

Using the response of speccode, you can use break in a condition. For example : if (my condition) break;

Upvotes: 0

Andrea Ascari
Andrea Ascari

Reputation: 21

Use the break; word in your while.

http://php.net/manual/en/control-structures.break.php

Upvotes: 0

speccode
speccode

Reputation: 1562

You don't need that for loop:

$i = 1;
while($row = $result->fetch_assoc()) {
    echo'<tr>
            <td>'.$i++.'</td>
            <td>'.$row['supplier'].'</td>
            <td>'.$row['item_name'].'</td>
            <td>'.$row['item_description'].'</td>
            <td>'.$row['quantity'].'</td>
            <td>'.$row['unit'].'</td>
            <td>'.number_format($row['unit_cost'], 2, '.', ',').'</td>
            <td>'.number_format($row['total_amount'], 2, '.', ',').'</td>
        </tr>';
}

Upvotes: 2

Related Questions