<?php
//connect to db
require('fileFuncs.inc');
$db_connect_path = FindInParentDir(getcwd(), 'db_connect_info.inc', 10,'server',$folder=False);
require($db_connect_path);
connectToRotaryDb(); //use your own function's name.

function setRotarySwitchState($name,$position){

	//check if person already has made a selection
	$selection = '';
	$query = "SELECT `status` FROM rollcall WHERE `name`=\"$name\"";
	$result = mysql_query($query) or die(mysql_error());
	while($row=mysql_fetch_array($result)){
		$selection=trim($row['status']);
	}

	$query=false;
	if((strlen($selection)<2)){
		//add new switch state
		$query = "INSERT INTO rollcall (`name`, `status`) VALUES ('".$name."', '".$position."')";
	}
	elseif ($selection != $position) {
		//update existing
		$query = "UPDATE  rollcall SET  `status` =  '".$position."' WHERE  `name` =  '".$name."'";
	}
	if($query){ //send update
		$result = mysql_query($query) or die(mysql_error());
	}
	
}
$name = mysql_real_escape_string($_GET['name']);
$position = mysql_real_escape_string($_GET['position']);
setRotarySwitchState($name,$position);
?>