RE: [PHP] Agh! Driving me crazy!
| From: | Michael Sweeney | Date: | Wed, 18 Jun 2003 19:56:00 +0000 |
| Subject: | RE: [PHP] Agh! Driving me crazy! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-152053@lists.php.net to get a copy of this message | ||
Also, you might have problems with the array reference $place[1] not
expanding from within the string - you might need to concatenate the
string around it:
...'$cases', '". $place[1] ."', '$iice'...
..michael..
On Wed, 2003-06-18 at 12:05, Jennifer Goodie wrote:
> You are missing the closing ) around the values you are inserting.
>
> > Anyone see anything wrong with this line of code?
> >
> > $fine = mysql_query("INSERT INTO
> > tblPOItems(poID,poItemUPC,poItemNumber,poItemDescription,poItemInn
> > erCasePkg,
> > poInnerQuantity,poItemEstQuantity,poItemCostEach,poItemSuggestedSellPrice)
> > values('$poID', '$place[0]', '$inmb', '$ides',
> > '$iicp', '$cases',
> > '$place[1]', '$iice', '$isgs'");
> >
> > I keep getting:
> >
> > Query failed: You have an error in your SQL syntax near '' at line 1 Query
> > was: 1064 exiting.
> >
--
Michael Sweeney <sweeney@verisity.com>
Verisity Design, Inc