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 <[EMAIL PROTECTED]>
Verisity Design, Inc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
