In your database product page, you can add this javascript:


<SCRIPT LANGUAGE="JavaScript">
//<!-- hide this script

function checkQty(form){

var minQty = parseInt(0);
var fldQty = parseInt(0);

     for(i=0;i<form.elements.length;i++){
          var fldName = form.elements[i].name;
          var fldQty = 0;
          if(fldName.substring(0,5) == "item-"){
		  	if(form.elements[i].value != ""){
                    var testqty = form.elements[i].value;
				fldQty = parseInt(testqty);
                    break;
			}
          }
     }

     if(form.elements['min_qty'].value != ""){
          var minQtyFld = form.elements['min_qty'].value;
          minQty = parseInt(minQtyFld);
     }

     if(fldQty < minQty){
          alert("You must order at least " + minQty + " of this item.");
          return false;
     }
     else{
          return true;
     }
}
// -->
</SCRIPT>



and then use one of the USER fields to set the minimum qty. Just enter the minimum number in the USER1 field.

Add this to the product row in the database product page:

<INPUT TYPE="hidden" NAME="min_qty" VALUE="USER_1">


Finally, we need to trigger it. Change the add to cart button to this:


<input class="buttons" type="submit" name="add_to_cart" value="Add To Cart" onClick="return checkQty(this.form);">