gracias por sus rpuestas pero los solucione de la siguiente forma:
Código PHP:
$sql_ultimo = "SELECT * FROM " .$tabla_bd. " WHERE flag = 1 ORDER BY id DESC LIMIT 1";
$consulta_ult_reg = $db->select($sql_ultimo);
$muestra_ultimo_reg = $db->get_row($consulta_ult_reg, 'MYSQL_BOTH');
$coordenadas = $muestra_ultimo_reg['coordenadas'];
$coord_bd = explode("-", $coordenadas);
$X_bd = $coord_bd[0];
$Y_bd = $coord_bd[1];
$sql_actual = "SELECT * FROM " .$tabla_bd. " WHERE id = " .$id;
$consulta_actual = $db->select($sql_actual);
$muestra_actual = $db->get_row($consulta_actual, 'MYSQL_BOTH');
switch($X_bd):
case 562:
$X = "105";
$Y = "684";
break;
case 105:
$X = "235";
$Y = "568";
break;
case 235:
$X = "236";
$Y = "781";
break;
case 236:
$X = "300";
$Y = "678";
break;
case 300:
$X = "400";
$Y = "528";
break;
case 400:
$X = "475";
$Y = "696";
break;
case 475:
$X = "370";
$Y = "841";
break;
case 370:
$X = "550";
$Y = "502";
break;
case 550:
$X = "562";
$Y = "868";
break;
default;
$X = "105";
$Y = "684";
break;
endswitch;
compare el ultimo registro y asigne en relacion a el...
saludos