function generateReadNoteSql($noteId) { $noteSql = ""; $noteSql .= "SELECT * FROM bc_note WHERE "; $noteSql .= formatSqlSetNumericValue('note_id', $noteId, false); return $noteSql; }
function generateLoadSpeciesSql($groupId) { $querySql = ""; $querySql .= "SELECT * FROM bc_species WHERE "; $querySql .= formatSqlSetNumericValue('bird_group_id', $groupId, false); $querySql .= " ORDER BY bc_species_seq"; return $querySql; }