Re: mysql query

On 8/21/2013 7:48 PM, Ethan Rosenberg wrote:

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 Ethan - you are simply missing two dollar signs as pointed out. Once you correct them, if there are any more errors you should then be seeing the message from mysqli_error.

And as for the advice to dump single quotes, I'd ignore it. The use of double and single quotes is a very handy feature and makes for very readable code. Escaping double quotes is such a royal pia and makes for more trouble deciphering code later on. The sample you provided for us is some of the best and most understandable code you've ever showed us.