Pra que serve a linha KEY `ip`?<?
$host = "localhost";
$login = "miranda";
$senha = "******";
$db = "uol";
$tabela = "uol";
mysql_connect($host, $login, $senha) or die (mysql_error());
mysql_select_db($db);
$timestamp = "time()";
$timeout = "time()-1";
$ip = "$REMOTE_ADDR";
$sql = mysql_query("INSERT INTO $tabela (timestamp, ip) VALUES ('$timestamp','$ip')");
$sql = mysql_query("DELETE FROM $tabela WHERE timestamp<$timeout");
$sql = mysql_query("SELECT DISTINCT ip FROM $tabela") or die(mysql_error());
$usuarios = mysql_num_rows($sql);
mysql_close();
if ($usuarios == 1)
{
echo"Há $usuarios usúario online ";
}
else
{
echo"Há $usuarios usúarios online ";
}
?>
CREATE TABLE `uol` (
`timestamp` int(15) NOT NULL default '0',
`ip` varchar(40) NOT NULL default '',
PRIMARY KEY (`timestamp`),
KEY `ip` (`ip`)
) TYPE=MyISAM;
Edição feita por: Miranda, 02/10/2004, 22:45.