query($d_update); } $db->query("SELECT * FROM distrib WHERE d_login='".$_SESSION['SESS_MEMBER_ID']."'"); if($db->num_rows()==0){ $q = "INSERT INTO distrib VALUES('','".$_SESSION['SESS_MEMBER_ID']."','dkusa123','New Company','','','','','','','',"; $q .= "'','','','','','','','','','','0')"; $db->query($q); $db->query("SELECT * FROM distrib ORDER BY d_ID DESC LIMIT 0,1"); } $db->next_record(); $d_ID = $db->f('d_ID'); $d_login = $db->f('d_login'); $d_pass = $db->f('d_pass'); $d_name = $db->f('d_name'); $customerNumber = $db->f('d_cust_num'); if($sessionID==''){ $today = date('Y-m-d_H:i:s'); $sessionID = $today."_".$d_ID; //$sessionID = urlencode($sessionID); } //add items to current order if($action=='Add To Order'){ $items = explode("+",$fids); for($i=1;$iquery($q); //update existing quantity if($db->num_rows()==1){ $db->next_record(); $newQty = $db->f('orderQty') + $quantity; $update = "UPDATE orders SET orderQty='$newQty' WHERE orderID='".$db->f('orderID')."'"; $db->query($update); } //insert new item else{ $insert = "INSERT INTO orders VALUES('','$sessionID','$d_ID','$ndx_part','$quantity','')"; $db->query($insert); } } $sys_message = "

***Items Added To Your Order***

"; } //update order if($action=="Update Order"){ $ids = explode("+",$fids); for($i=1;$iquery($query); $sys_message = "

***Order Updated***

"; } } ?>