Re: Re: mysql query

On 08/22/2013 09:51 AM, Jim Giner wrote:

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. Jim -

Thanks for the complement. Ethan