Stumped I Tell You!
| From: | Jay Blanchard | Date: | Fri, 25 Jul 2008 17:55:05 +0000 |
| Subject: | Stumped I Tell You! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-277326@lists.php.net to get a copy of this message | ||
$getEnd = "select a.ACCOUNTID as CONTRACT, a.BALANCE/10000 as BALANCE,
b.STATUS, b.IMSI_ID as MDN, b.IMEI_ID as ESN, ";
$getEnd .= "b.EQUIP_ID as MIN, b.MKT, b.MARKET_NAME ";
$getEnd .= "FROM work.account_".$startDate." a ";
$getEnd .= "JOIN work.customer_".$startDate." b ";
$getEnd .= "ON ( b.CONTRACT_ID = a.ACCOUNTID AND b.RUNDATE =
date_sub(a.BC_ACCOUNT_ARC_DATE, interval 1 day)) ";
$getEnd .= "WHERE a.BC_ACCOUNT_ARC_DATE =
str_to_date('".$endDate."','%Y%m%d') ";
$getEnd .= "AND a.ACCOUNTID = '".$acct['CONTRACT']."' ";
$getEnd .= "AND a.status = 1 ";
$getEnd .= "AND a.balance > 0 ";
if(!$dbEnd = (mysql_query($getEnd, $dbc))){
echo mysql_error() . "\n";
exit();
}
echo $getEnd;
returns....
select a.ACCOUNTID as CONTRACT, a.BALANCE/10000 as BALANCE, b.STATUS,
b.IMSI_ID as MDN, b.IMEI_ID as ESN, b.EQUIP_ID as MIN, b.MKT,
b.MARKET_NAME FROM work.account_20080601 a JOIN work.customer_20080601 b
ON ( b.CONTRACT_ID = a.ACCOUNTID AND b.RUNDATE =
date_sub(a.BC_ACCOUNT_ARC_DATE, interval 1 day))
WHERE a.BC_ACCOUNT_ARC_DATE = str_to_date('20080602','%Y%m%d')
AND a.ACCOUNTID = '1000080'
AND a.status = 1
AND a.balance > 0
...which works from the command line.
$endBal = mysql_fetch_array($dbEnd);
echo mysql_num_rows($dbEnd);
print_r($endBal);
Nothing gets returned from those last statements. Am I missing something
completely?