Simple PHP code question

[DigitalShadow]

<div class="reportBox10">
<?php $sent1 = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '6' ");?>
<?php $sent2 = $db->Execute("select count(*) as count from " . TABLE_ORDERS_2 . " where orders_status = '6' ");?>
<?php $last1 = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '7' ");?>
<?php $last2 = $db->Execute("select count(*) as count from " . TABLE_ORDERS_2 . " where orders_status = '7' ");?>
<div class="header10">
<?php 
if ($sent1->fields['count'] < 1) { 
echo 'It must be Monday, ' . $sent1->fields['count'] . ' packages sent so far.'; 
} elseif ($sent1->fields['count'] <= 500) { 
echo 'Good Job! ' . $sent1->fields['count'] . ' packages sent this week!'; 
} else { 
echo 'Wow, great work! You have sent ' . $sent1->fields['count'] . ' packages this week!'; 
}
?>
</div>
</div>

What I want to do is have it so it can get the two database fields added together

$sent1 + $sent2

and then use them in the if argument together so the totals are used...

[RodG]

<div class="reportBox10">
<?php $sent1 = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '6' ");?>
<?php $sent2 = $db->Execute("select count(*) as count from " . TABLE_ORDERS_2 . " where orders_status = '6' ");?>
<?php $last1 = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '7' ");?>
<?php $last2 = $db->Execute("select count(*) as count from " . TABLE_ORDERS_2 . " where orders_status = '7' ");?>
<div class="header10">
<?php 
if ($sent1->fields['count'] < 1) { 
echo 'It must be Monday, ' . $sent1->fields['count'] . ' packages sent so far.'; 
} elseif ($sent1->fields['count'] <= 500) { 
echo 'Good Job! ' . $sent1->fields['count'] . ' packages sent this week!'; 
} else { 
echo 'Wow, great work! You have sent ' . $sent1->fields['count'] . ' packages this week!'; 
}
?>
</div>
</div>

What I want to do is have it so it can get the two database fields added together

$sent1 + $sent2

and then use them in the if argument together so the totals are used...

What's wrong with using the 'obvious' method:

------------------------------------------------------
<?php
$sent = $sent1->fields['count'] + $sent2->fields['count'] ;

if ($sent < 1) {
do stuff
}

---------------------------------------------------------

Cheers
Rod

[DigitalShadow]

What's wrong with using the 'obvious' method:

Nothing, I just suck at code!

[RodG]

Nothing, I just suck at code!

LOL. Not exactly the answer I was expecting.

If my suggestion doesn't work 'as is' - it will be because I didn't account for datatype (It shouldn't be possible to add two strings together to produce a numeric result, even though PHP does generally allow it).

Better code to use would be:
$sent = (intval)$sent1->fields['count'] + (intval)$sent2->fields['count'] ;

This will convert the count values to integers before adding them, thus mitigating datatype mismatch errors before they can occur.

Cheers
Rod

[DigitalShadow]

With a little bit of modification got the code to work just fine, thank you.