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> 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
Toby -
The problem is that I do not get any error messages.
From this
if (!$result2)
die('Could not enter data: ' . mysqli_error());
I only get the 'Could not enter data: and no error message.
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
