Turn on error reporting/logging/displaying and what errors are you getting?
And as you said ...
$result10 = mysqli_query($cxn, $sql10);
var_dump($result1); // this returns NULL
is your actual code, maybe ...
<?php
$a = 'set variable a to this message';
var_dump($b);
?>
gives you a better clue?
On 23 June 2013 23:06, Ethan Rosenberg, PhD <[email protected]
> wrote:
>
>
>
>
> On 23 June 2013 21:37, Ethan Rosenberg, PhD <erosenberg@hygeiabiomedical.*
> *com <[email protected]>> wrote:
>
> On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote:
>
> Dear List -
>
> There is an error in my query, and I cannot find it.
>
> This fails:
>
> $_SESSION['Cust_Num'] = $_REQUEST['cnum'];
> $_SESSION['CustNum'] = $_REQUEST['cnum'];
>
> echo "session<br />"; //this has the proper values
> print_r($_SESSION);
>
> $sql10 = "select Balance, Payments, Charges, Date from Charges
> where
> Cust_Num = $_SESSION[Cust_Num] order by Date";
> echo $sql10; //echos the correct query
> $result10 = mysqli_query($cxn, $sql10);
> var_dump($result1); // this returns NULL
>
>
> Against my better judgement, here I go again.
>
> Is this the "actual" code you executed, or is it once again a typeover?
>
> Your 1st error is in these two lines:
>
> $result10 = mysqli_query($cxn, $sql10);
>
> var_dump($result1); // this returns NULL
>
>
> Yes your dump returns null. And always will.
>
>
> Any further errors might be related to your non-standard syntax for
> the session variable. Per the manual, associative arrays using string
> indices should always use ' ' around them. They work (as mentioned in the
> manual) but are wrong.
> =======
> Jim -
>
>
>
> Is this the "actual" code you executed, or is it once again a typeover?
>
> The actual code
>
>
> Any further errors might be related to your non-standard syntax for
> the session variable. Per the manual, associative arrays using string
> indices should always use ' ' around them. They work (as mentioned in the
> manual) but are wrong.
>
> Newbie is confused.
>
> Please explain.
>
>
> Try ...
>
> $sql10 = "select Balance, Payments, Charges, Date from Charges where
> Cust_Num = {$_SESSION['Cust_Num']} order by Date";
>
>
> --
> Richard Quadling
> Twitter : @RQuadling
> EE : http://e-e.com/M_248814.html
> Zend : http://bit.ly/9O8vFY
> =========
> Tried it. No luck
>
> Ethan
>
--
Richard Quadling
Twitter : @RQuadling
EE : http://e-e.com/M_248814.html
Zend : http://bit.ly/9O8vFY
