Re: mysql query

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