Deciding which cover crop to use:

This is an online tool to help you quickly narrow the choices of cover crop for your situation. In a few seconds, you will have growing instructions for the cover crop that will do the job you need.

    1. Choose one or more criteria, and click SUBMIT.
    2. Choose the suggestions that best fit your situation.
    3. Click on the name of the cover crop to get precise growing instructions.
    4. If you get no hits, then there is not a good cover crop for the combination you selected. Try different criteria.
[insert_php]

$management_goal=$_POST[‘management_goal’];
$planting_time=$_POST[‘planting_time’];
$duration=$_POST[‘duration’];
$Submit=$_POST[‘Submit’];
?>

Autumn


/* The $PT below sets the sql search condition. if nothing has been entered in the planting time box then
I want everything selected. If a selection is made like winter I don’t want Early Winter returned so the condition switches to the =. */
if($planting_time==””) {
$PT = “crop_lut.planting_time LIKE ‘%$planting_time%'”;
}else{
$PT = “crop_lut.planting_time = ‘$planting_time'”;
}
mysql_select_db($database, $connect) or die( “Unable to select database”); $result = mysql_query(“SELECT * FROM crop_lut, crop_data WHERE crop_lut.management_goal LIKE ‘%$management_goal%’ AND $PT AND crop_lut.duration LIKE ‘%$duration%’ and crop_lut.crop = crop_data.crop_name GROUP BY crop_name”); $num=mysql_num_rows($result);
/* echo “Number of matches: $num

“; */
/* Using the .= variable below I’m building the table across based on the returned values then that gets echoed out below as the td variable. */
while($row = mysql_fetch_array($result)){
$crop .= ”

“.”
“.($row[‘crop’]).”“;
$seed .= ”

“.($row[‘seeding_rate’]).””;
$seedcost .= ”

“.($row[‘seed_cost’]).””;
$seeddate .= ”

“.($row[‘seeding_dates’]).””;
$time .= ”

“.($row[‘time_until_control’]).””;
$supply .= ”

“.($row[‘seed_suppliers’]).””;
$goals .= ”

“.($row[‘management_goals’]).””;
$tricks .= ”

“.($row[‘management_tricks’]).””;
$unavoidable .= ”

“.($row[‘unavoidable_problems’]).””;
$avoidable .= ”

“.($row[‘avoidable_problems’]).””;
$classic .= ”

“.($row[‘classic_uses’]).””;
}
?>

 

Crop
Seeding Rate
Seed Cost
Seeding Dates
Time Until Control
Seed Suppliers
Management Goals
Management Tricks
Unavoidable Problems
Avoidable Problems
Classic Uses

[/insert_php]