mysql query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux