$getEnd = select a.ACCOUNTID as CONTRACT, a.BALANCE/1 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 =
On Fri, Jul 25, 2008 at 1:55 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
[snip!]
$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?
Right here
?php
// Code
[snip]
[snip!]
$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?
Right here
?php
// Code before
if(!$dbEnd = (mysql_query($getEnd, $dbc))){
echo
On Fri, Jul 25, 2008 at 2:36 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
I have several other queries running in this example and they all use
the same run/error check routine with no issues.
I'm sure you've already tried this, but did you copy the SQL query
echo'd out and try it directly
[snip]
I'm sure you've already tried this, but did you copy the SQL query
echo'd out and try it directly with MySQL to make sure there are rows
returned?
[/snip]
Yes.
*slaps forehead soundly* I found that there was a missing greater than
sign in a greater than or equal to requirement in an
On Fri, Jul 25, 2008 at 3:07 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
*slaps forehead soundly* I found that there was a missing greater than
sign in a greater than or equal to requirement in an earlier query.
The most minuscule errors cause the greatest harm.
By the way, I didn't
On 7/25/08, Daniel Brown [EMAIL PROTECTED] wrote:
On Fri, Jul 25, 2008 at 3:07 PM, Jay Blanchard [EMAIL PROTECTED]
wrote:
*slaps forehead soundly* I found that there was a missing greater than
sign in a greater than or equal to requirement in an earlier query.
The most minuscule
[snip]By the way, I didn't mean to insinuate that your use of the
if()
condition was incorrect[/snip]
No worries.
[snip] Someone needs to whack me upside the head every so often. In my
case, that might be a patentable invention.[/snip]
I see you get whacked around the head here every so
On Fri, Jul 25, 2008 at 3:41 PM, Jay Blanchard [EMAIL PROTECTED] wrote:
I see you get whacked around the head here every so often...and if not
here I am sure that your SO handles it as needed.
Yeah, but she's in Virginia Beach for the week, so there's a
slight chance the bruising will
9 matches
Mail list logo