Embed WA_MySQLi_RS in functions
Can I embed webassist database queries in functions? I have regular functionality that I want to put in a library file rather than put in many places this is what I am trying.
In a separate file:
function getSelectedGrowingSeason($yearID){
$RSGrowingSeasonSelectedYear = new WA_MySQLi_RS("RSGrowingSeasonSelectedYear",$Old4thDB_i,1);
$RSGrowingSeasonSelectedYear->setQuery("SELECT growingseasonsYear FROM growingseasons WHERE growingseasons_id = ?");
$RSGrowingSeasonSelectedYear->bindParam("i", "".(isset($_GET['growingseasons_id'])?$_GET['growingseasons_id']:"") ."", "-1"); //colname
$RSGrowingSeasonSelectedYear->execute();
$year = $RSGrowingSeasonSelectedYear->getColumnVal("growingseasonsYear");
return $year;
}