/** obtain a list of exercises for a particular user */
public function getExercisesForUser( $username ) {
global $mysql_info;
DBTools::connect( $mysql_info );
$user = mysql_real_escape_string( $username );
$rows = DBTools::doMultiRowQuery( "SELECT id FROM exercises where username=\"$username\" AND (completion<100 OR completion IS NULL) LIMIT 1" );
$exercises = array();
foreach ( $rows as $row ) {
$exercises[] = (int) $row["id"];
}
return $exercises;
}
