Stumped I Tell You!
- From: jblanchard@xxxxxxxxxx ("Jay Blanchard")
- Date: Fri, 25 Jul 2008 12:55:05 -0500
$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?
.
- Follow-Ups:
- Re: [PHP] Stumped I Tell You!
- From: "Daniel Brown"
- Re: [PHP] Stumped I Tell You!
- Prev by Date: Re: [PHP] Code beautifier
- Next by Date: Re: [PHP] Code beautifier
- Previous by thread: Re: [PHP] Code beautifier
- Next by thread: Re: [PHP] Stumped I Tell You!
- Index(es):
Relevant Pages
|
