Re: Re: Problem with query

On 23 June 2013 21:37, Ethan Rosenberg, PhD <[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