Re: multiple inserts into a db

On Wed, May 18, 2005 9:47 pm, mayo said: > $ses_basket_items is the total number of items > $orderID = the orderID which these items are a part of > $ses_basket_id = is the itemID number Which item ID number? Cuz, like, you've got FOUR different itemID numbers. Something isn't making sense here... > for ($i=0;$i<$ses_basket_items;$i++){ > > $query = "INSERT INTO orderedItems (orderID,itemID) VALUES > ('$orderID','$ses_basket_id')"; echo $query, "<hr />\n"; You probably have an ARRAY of itemID numbers. You need to get each itemID number out of that array and get it into your query. > mysql_query($query) or die('Error, insert query failed'); > > } > > mysql_close($conn); You really do need to re-read the PHP Manual section about arrays and what they are and how they work... -- Like Music? http://l-i-e.com/artists.htm