PHP: While loop condition

Question

$result= db_query("SELECT dayoff FROM specificdayoff");
$node->frmdate = mktime(0,0,0, $node->frmdate['month'], $node->frmdate['day'],$node->frmdate['year']);
$node->todate = mktime(0,0,0, $node->todate['month'], $node->todate['day'],$node->todate['year']);
$node->dayoff = mktime(0,0,0, $node->dayoff['month'], $node->dayoff['day'],$node->dayoff['year']);
$data = $node->dayoff;
$frmdate = $node->frmdate;
$todate = $node->todate;    

$iii=0;
while($frmdate!=$todate)
{
    while($data= db_fetch_object($result))
    {
        if($frmdate==$data)
        {
            $iii++;
           //debug
        }

    }
    $frmdate=mktime(0, 0, 0, date("m", $frmdate), date("d", $frmdate)+1, date("Y", $frmdate));
    //debug2     
   }
$diff=$iii

I need every element of $frmdate to be compared with all element of $data. but when I run this code, $diff keep returning 0. meaning to say, there's something wrong with my if statement, but I can't seem to figure out what is wrong with it.

when I debug this block of code, both while loop did not run as i want it. the 2nd while loop only run once. I need the 2nd while loop to be run every time 1st while loop is running. any help?

the debug run like this: debug debug debug debug2 debug2 debug2

i need it to run like this: debug debug debug debug2 debug debug debug debug2 debug debug debug debug2

It also looks like you are comparing an object ($data) to an integer (timestamp $frmdate). I would check what you are expecting from db_fetch_object — phindmarsh
– phindmarsh, Commented Oct 12, 2011 at 1:55
@BrendanLong cuz i do not want any addition to $iii when $frmdate not equal to $data — Cooper
– Cooper, Commented Oct 12, 2011 at 1:58
@Cooper - So just leave the else out. You don't need one. if statements are perfectly fine alone. — Brendan Long
– Brendan Long, Commented Oct 12, 2011 at 2:00
@phindmarsh do u know any way i could compare these two variable ($data, $frmdate). i expect db_fetch_object would fetch the 'dayoff' field in the database. the 'dayoff' field contains timestamp. i need to compare this dayoff field with $frmdate. — Cooper
– Cooper, Commented Oct 12, 2011 at 2:01

phindmarsh · Accepted Answer · 2011-10-12 02:23:16Z

1

I get the feeling you have a timestamp in your specificdayoff table. If this is the case, then your db_fetch_object method will retrieve an object that has dayoff property.

To access this you would use $data->dayoff. So you need to change the condition of the if($frmdate==$data) to if($frmdata == $data->dayoff)

This is all a guess without knowing exactly what your db_fetch_object will return. That said, I still don't follow exactly what is supposed to be happening here, and this may just be one of a few problems you have.

answered Oct 12, 2011 at 2:23

phindmarsh

8796 silver badges11 bronze badges

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

3 Comments

Cooper Over a year ago

omg! it work! you're the man. $data->dayoff could change $data to integer! my if statement are workin now. thanks for the help man.

phindmarsh Over a year ago

@Cooper, no problem, I'm glad it helped. As mentioned above, if this or the other solution (by @Brendan) solves your problem, please mark it as accepted.

Cooper Over a year ago

both answer solves my problems. so i should mark both as accepted. right? sorry. a newbie here.

Marc B · Accepted Answer · 2011-10-12 02:12:28Z

1

$frmdate is a simple PHP timstamp, created by mktime(). You then compare this timestamp value agains an OBJECT created by a database fetch statement. A timestamp and a DB fetch object can never be equal, so your while loop's $iii++ can never get triggered.

answered Oct 12, 2011 at 2:12

Marc B

362k44 gold badges433 silver badges508 bronze badges

1 Comment

Cooper Over a year ago

no wonder i get 0 all the time. I've find the way to convert the fetch_object into timestamp so that it could be compared with $frmdate! thanks mate!

Brendan Long · Accepted Answer · 2011-10-12 02:24:14Z

1

You said the problem is this:

while($data= db_fetch_object($result))

What's happening is that after running through this loop once, you'll fetch all of the results, so there are none left. Going through the loop again, there's still no results because you already fetched them all. You need to set up $result again. You didn't include this, code but look for a line that looks like $result = ....

Something like this:

$node->frmdate = mktime(0,0,0, $node->frmdate['month'], $node->frmdate['day'],$node->frmdate['year']);
$node->todate = mktime(0,0,0, $node->todate['month'], $node->todate['day'],$node->todate['year']);
$node->dayoff = mktime(0,0,0, $node->dayoff['month'], $node->dayoff['day'],$node->dayoff['year']);
$data = $node->dayoff;
$frmdate = $node->frmdate;
$todate = $node->todate;    

$iii=0;
while($frmdate!=$todate)
{
    $result= db_query("SELECT dayoff FROM specificdayoff");
    while($data= db_fetch_object($result))
    {
        if($frmdate==$data)
        {
            $iii++;
        }
    }
    $frmdate=mktime(0, 0, 0, date("m", $frmdate), date("d", $frmdate)+1, date("Y", $frmdate));  
}
$diff=$iii

edited Oct 12, 2011 at 2:24

answered Oct 12, 2011 at 1:54

Brendan Long

54.5k21 gold badges154 silver badges194 bronze badges

3 Comments

Cooper Over a year ago

so, is there any function or way for me to make 2nd loop run everytime 1st loop is runnin? i already add variable declaration, query and debug result in the block of code.

Brendan Long Over a year ago

@Cooper - Set $result inside the outer loop.

Cooper Over a year ago

ohh. done! sorry. im still new. thanks for the help again brendan.

Collectives™ on Stack Overflow

PHP: While loop condition

3 Answers 3

3 Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related