myalert.php

<? // Nome deste arquivo: myalert.php ?>
<?
$con = mysql_connect("server", "login", "senha") or die('Falha na conexão :x');
$db = mysql_select_db("db?");

function ultimoID() {
$query = mysql_query("SELECT msg FROM alertas ORDER BY id DESC");
$ct = mysql_num_rows($query);
return $ct;
}

function getAlerta() {
$query = mysql_query("SELECT * FROM alertas ORDER BY id DESC LIMIT 1");
while($row = mysql_fetch_array($query)) {
$name = $row['login'];
$msg = $row['alerta'];
}
return $name.','.$msg;
}

function alertById($id) {
$query = mysql_query("SELECT * FROM alertas WHERE id = '$id'");
while($row = mysql_fetch_array($query)) {
$name = $row['login'];
$msg = $row['alerta'];
}
return $name.','.$msg;
}

$ac = $_GET['action'];
switch($ac) {
 case 1: ultimoID(); break;
 case 2: getAlerta(); break;
 case 3: alertById(addslashes($_GET['id'])); break;
}

?>