function price_validation1(value, colname) { if(value < 0){ return [false,colname + " must be zero a positive integer."]; } return [true, ""]; } // validation (INLINE only) function price_validation2(value, colname) { var rowId = jQuery("#products").jqGrid('getGridParam','selrow'); if(parseFloat(jQuery('#' + rowId + '_' + 'buyPrice').val()) > parseFloat(jQuery('#' + rowId + '_' + 'MSRP').val())) return [false,"buyPrice must be equal or less than MSRP."]; else return [true,""]; } // validation (FORM only) function price_validation3(value, colname) { if(parseFloat(jQuery('#buyPrice').val()) > parseFloat(jQuery('#MSRP').val())) return [false,"buyPrice must be equal or less than MSRP."]; else return [true,""]; } </script> <?php $dg = new C_DataGrid("SELECT * FROM products", "productCode", "products"); $dg->enable_edit('FORM'); $dg->set_col_customrule('quantityInStock', 'price_validation1'); $dg->set_col_customrule('buyPrice', 'price_validation3'); $dg->display();