PHP double while loop, second loop is running only once

Question

I want to print information with the help of second while loop, but it is running only once.

while($nextDate<$currentDate)
{
        $nextDate=date('Y-m-d',strtotime('+ 6 days',strtotime($weekDate))); 

        $qM="select count(*) as count ,Deposit.DepositNo, Deposit.DepositDate,
                     sum(DepositItem.Amount) as Amount,DAmount
                     from DepositItem
                     inner join Deposit on Deposit.DepositNo=DepositItem.DepositNo
                     where Deposit.DepositDate>='".$weekDate."' and Deposit.DepositDate<='".$nextDate."' group by Deposit.DepositNo 
                     order by Deposit.DepositNo desc";

        $connM=new dbconfig();
        $connM->connectdb();
        $connM->execute($qM);
        $amt=0;
        $damt=0;
        while($rowsM =$connM->fetch_row()) 
        {
            $amt=$amt+$rowsM['Amount'];
            $damt=$damt+$rowsM['DAmount'];
        }
}

you have not closed first while loop } is missing OR its just TYPO. — Yogesh Suthar
– Yogesh Suthar, Commented Feb 22, 2013 at 7:42
what o/p you are getting now? Also what is you expected o/p? — Vinoth Babu
– Vinoth Babu, Commented Feb 22, 2013 at 7:42
@Manu Srivastava may be your 2nd sql query is returning only one row. — Ripa Saha
– Ripa Saha, Commented Feb 22, 2013 at 7:44

Vlad Preda · Accepted Answer · 2013-02-22 08:02:52Z

Judging by your code, there are too many unknowns to figure out the issue.

But I wrote some comments in the code to point out potential problems / debugging suggestions:

// what are the (expected) values of $nextDate and $currentDate ?
while ($nextDate < $currentDate) {
    $nextDate = date('Y-m-d', strtotime('+ 6 days', strtotime($weekDate)));
    // this makes the big loop either run once (if $weekDate is within the 6 days interval)
    // or an infinite loop if it isn't

    $qM =   "select count(*) as count ,Deposit.DepositNo, Deposit.DepositDate,
             sum(DepositItem.Amount) as Amount,DAmount
             from DepositItem
             inner join Deposit on Deposit.DepositNo=DepositItem.DepositNo
             where Deposit.DepositDate>='" . $weekDate . "' and Deposit.DepositDate<='" . $nextDate . "' group by Deposit.DepositNo 
             order by Deposit.DepositNo desc";
    // do an echo $qM and copy it in Phpmyadmin, see if it returns expected results

    $connM = new dbconfig(); // not quite good to have these inside a loop
    $connM->connectdb(); // you should put these 2 lines outside
    $connM->execute($qM);
    $amt = 0;
    $damt = 0;
    while ($rowsM = $connM->fetch_row()) { // do a var_dump($rowsM) inside the loop
        $amt = $amt + $rowsM['Amount'];
        $damt = $damt + $rowsM['DAmount'];
    }
}

poojitha · Accepted Answer · 2013-02-22 07:42:54Z

0

$nextDate is always greater than $currentDate because you are adding 6 days

$nextDate=date('Y-m-d',strtotime('+ 6 days',strtotime($weekDate)));

answered Feb 22, 2013 at 7:42

poojitha

3351 gold badge3 silver badges13 bronze badges

2 Comments

Nick Pickering Over a year ago

Not sure that's true. is $weekDate the same as $currentDate?

Vlad Preda Over a year ago

Not necessarily, we don't know the value of $weekDate. If would seem to me that the first while would either run once, or an infinite loop, since $weekDate isn't changed :)

Collectives™ on Stack Overflow

PHP double while loop, second loop is running only once

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related