Re: mysql query

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!). 2. Check that the SQL statement concatenation in PHP is building the string you're expecting. It looks like you're joining 2 strings when defining $sql2 that doesn't leave a space between the close parentheses and "values." Compare this against what you're sending "on the command line." 3. Get rid of all single quotes... escape your double quotes where needed. This will avoid any variable-in-string interpolation errors and may help you find the issue with input data. Same with your echo $sql2 statement... that's not going to give you the same thing as the print_r below it. Thanks, Daniel Krook Software Engineer, Advanced Cloud Solutions, GTS IBM Senior Certified IT Specialist - L3 Thought Leader The Open Group Certified IT Specialist - L3 Distinguished Cloud, Java, PHP, BlackBerry, DB2 & Solaris Certified Ethan Rosenberg <erosenberg@hygeiabiomedical.com> wrote on 08/21/2013 07:48:12 PM: > From: Ethan Rosenberg <erosenberg@hygeiabiomedical.com> > To: PHP Database List <php-db@lists.php.net> > Date: 08/21/2013 07:48 PM > Subject: [PHP-DB] mysql query > > Dear List - > > I can't figure this out.... > > mysql> describe Inventory; > +-------------+-------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-------------+-------------+------+-----+---------+-------+ > | UPC | varchar(14) | YES | | NULL | | > | quant | int(5) | NO | | NULL | | > | manuf | varchar(20) | YES | | NULL | | > | item | varchar(50) | YES | | NULL | | > | orderpt | tinyint(4) | NO | | NULL | | > | ordrpt_flag | tinyint(3) | YES | | NULL | | > | stock | int(3) | YES | | NULL | | > +-------------+-------------+------+-----+---------+-------+ > > Here are code snippets - > > $upc = $_SESSION['UPC']; > $qnt = $_POST['quant']; > $mnf = $_POST['manuf']; > $itm = $_POST['item']; > $odrpt = $_POST['oderpt']; > $opf = $_POST['ordrpt_flag']; > $stk = $_POST['stock']; > > $sql2 = "insert into Inventory (UPC, quant, > manuf, item, orderpt, ordrpt_flag, stock)" > ."values ('$upc', > $qnt,'$mnf','$itm', > odrpt, 0, $stk)"; > $result2 = mysqli_query(cxn, $sql2); > echo '$sql2<br />'; > print_r($sql2); > echo "<br />$upc $qnt $mnf $itm $odrpt $opf > $stk<kbr />"; > if (!$result2) > die('Could not enter data: ' . > mysqli_error()); > > The mysql query fails. I cannot figure out why. It works from the > command line. > > TIA > > Ethan > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >