Re: Problem wkith Query

On 23 June 2013 21:37, Ethan Rosenberg, PhD <erosenberg@hygeiabiomedical.com> 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