'' and $relateselect<>'') { $message="Unable To use both a new realtion type and a selected type"; } else { if ($relatetype=='' and $relateselect=='') { $message="Must have a relation type or selected type"; } else { if ($relatetype=='') { $relatetype=$relateselect; } $s="SELECT * FROM stocklist_tarriffs_related_items where (stock_ref='$addstk' and related_stock_ref='$stkref') or (stock_ref='$stkref' and related_stock_ref='$addstk')"; $result=getquery($s); $numr=mysql_num_rows($result); if ($numr>0) { $message="Unable To ALL relation as Item is already Related"; } else { $addedon=date(U); $i="INSERT INTO stocklist_tarriffs_related_items (stock_ref , related_stock_ref , addedby , addedon , relation_type) VALUES ('$stkref','$addstk','$localname','$addedon','$relatetype')"; getquery($i); $message="New Relation Added"; } } } ?>