Here is the previously updated recordset. My understanding is that the get_magic_quotes_gpc and "addslashes" were for security reasons. They are no longer necessary with mysqli? Can the complete line "$colname1_rsBIBinventory = ( get_magic_quotes_gpc() ) ? $_POST[ 'BPeCart6_1_SizeID_Add' ] : addslashes( $_POST[ 'BPeCart6_1_SizeID_Add' ] );" safely be deleted after the recordset uses mysqli?
$colname1_rsBIBinventory = ( get_magic_quotes_gpc() ) ? $_POST[ 'BPeCart6_1_SizeID_Add' ] : addslashes( $_POST[ 'BPeCart6_1_SizeID_Add' ] );
becomes:
$colname1_rsBIBinventory = $_POST[ 'BPeCart6_1_SizeID_Add' ] ;
For reference:
$query_rsBIBinventory = sprintf( "SELECT * FROM product_inventory WHERE ProductID = 23 and SizeID = %s and ColorID = %s and Option1 = %s", GetSQLValueString( $colname1_rsBIBinventory, "int" ), GetSQLValueString( $colname2_rsBIBinventory, "int" ), GetSQLValueString( $colname3_rsBIBinventory, "int" ) ); //make the query string
$rsBIBinventory = $conn_dbi->query( $query_rsBIBinventory );
$row_rsBIBinventory = $rsBIBinventory->fetch_assoc();