Re: Re: mysql query

Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking only at the free ones :D On Thu, Aug 22, 2013 at 9:24 PM, Jim Giner <jim.giner@albanyhandball.com>wrote: > On 8/22/2013 9:52 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. >> >> Also - Ethan - if you used an editor that was designed for php you > probably would have seen these missing $ signs since a good one would > highlight php syntax and the lack of the $ would have produced a different > color than you expected. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >