function adminGetInOutRecordsForPerson($db, $personid, $limit=0)
{
    // rerturns a my-sql query result set


    if ($db && $personid)
    {

	if ($limit>0)
	{
	    // only return up to the number of results specified

	return(mysql_query_log(

	    "SELECT InOutTime.id AS inoutid"
	    . ", InOutTime.recorddate AS recorddate"
	    . ", InOutTime.indatetime AS indatetime"
	    . ", InOutTime.outdatetime AS outdatetime"
	    . ", DATE_FORMAT(InOutTime.indatetime, '%H:%i') AS displayintime"
	    . ", DATE_FORMAT(InOutTime.outdatetime, '%H:%i') AS displayouttime"
	    . ", InOutTime.breakminutes AS breakminutes"
	    . ", InOutTime.extraminutes AS extraminutes"
	    . ", InOutTime.comments AS comments"
	    . ", LEFT(InOutTime.comments, 10) AS shortcomments"
	    . ", DayTypeValues.daytype AS daytype"

		// below we actually calculate totalhours for display
		. ", ( IF ((InOutTime.indatetime='1001-01-01 00:00:00' OR InOutTime.outdatetime='1001-01-01 00:00:00'), '', TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(InOutTime.outdatetime) - UNIX_TIMESTAMP(InOutTime.indatetime)- (InOutTime.breakminutes * 60)+(InOutTime.extraminutes * 60)), '%H:%i'))) AS totalhours "
	    . " FROM InOutTime, DayTypeValues"
	    . " WHERE InOutTime.personid=" . $personid	    
	    . " AND InOutTime.daytypeid=DayTypeValues.id"
	    . " ORDER BY recorddate DESC LIMIT " . $limit

	    , $db));

	}
	else
	{
	    // Return ALL the records for this person

	return(mysql_query_log(

	    "SELECT InOutTime.id AS inoutid"
	    . ", InOutTime.recorddate AS recorddate"
	    . ", InOutTime.indatetime AS indatetime"
	    . ", InOutTime.outdatetime AS outdatetime"
	    . ", DATE_FORMAT(InOutTime.indatetime, '%H:%i') AS displayintime"
	    . ", DATE_FORMAT(InOutTime.outdatetime, '%H:%i') AS displayouttime"
	    . ", InOutTime.breakminutes AS breakminutes"
	    . ", InOutTime.extraminutes AS extraminutes"
	    . ", InOutTime.comments AS comments"
	    . ", LEFT(InOutTime.comments, 10) AS shortcomments"
	    . ", DayTypeValues.daytype AS daytype"
		// below we actually calculate totalhours for display
		. ", ( IF ((InOutTime.indatetime='1001-01-01 00:00:00' OR InOutTime.outdatetime='1001-01-01 00:00:00'), '', TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(InOutTime.outdatetime) - UNIX_TIMESTAMP(InOutTime.indatetime)- (InOutTime.breakminutes * 60)+(InOutTime.extraminutes * 60)), '%H:%i'))) AS totalhours "
	    . " FROM InOutTime, DayTypeValues"
	    . " WHERE InOutTime.personid=" . $personid
	    . " AND InOutTime.daytypeid=DayTypeValues.id"
	    . " ORDER BY recorddate DESC"

	    , $db));

	}

    }

}   // adminGetInOutRecordsForPerson()