multiple inserts into a db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm putting ordered items into a db. The information is stored in
session variables.
 
Session_variable_with_itemID_has(1001,1002,1003,1004) however when
inserted into the db only 0,0,0,0 is recorded.
 
Assuming that this was the 40th recorded order the table should look
like this
 
TABLE: orderedItems
 
orderedItemsID -- orderID - itemID
 
159 - 40 - 1001
160 - 40 - 1002
161 - 40 -- 1003 
162 - 40 - 1004
 
What comes out is:
 
orderedItemsID -- orderID - itemID
 
159 - 40 - 0
160 - 40 - 0
161 - 40 -- 0 
162 - 40 - 0
 
 
The loop itself works as intended. However it is not inserting this
variable.
 
$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
 
 
 
            for ($i=0;$i<$ses_basket_items;$i++){
 
            $query = "INSERT INTO orderedItems (orderID,itemID) VALUES
('$orderID','$ses_basket_id')";
 
            mysql_query($query) or die('Error, insert query failed');
 
            }
 
            mysql_close($conn);
 
thx
 

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux