Dear List -
I can't figure this out
mysql> describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| UPC | varchar(14) | YES | | NUL
1) What is the error message?
2) This has an error:
>values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql> describe Inventory;
+-+-+-
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote:
1) What is the error message?
2) This has an error:
>values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql> des
Ethan,
It's hard to tell from the code formatting in your email what the exact
problem might be, but a few reasons that this might fail in PHP rather
than when sent to MySQL with hardcoded values:
1. var_dump/print_r $_POST to see what you're getting as input is what
you expect (and sanitize!
Ethan,
What about:
$result2 = mysqli_query(cxn, $sql2);
Doesn't look like you're sending it a connection link as a variable ($cxn)
and that's passed through as a literal?
Thanks,
Daniel Krook
Software Engineer, Advanced Cloud Solutions, GTS
IBM Senior Certified IT Specialist - L3 Thought