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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php