Viewing file:  varios.php (1.21 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include "../frames/conn.php";
/*
$sql="SELECT t1.nick , t1.titulo FROM estadistica as t1 where t1.accion='clave' group by t1.nick";
$res=mysql_query($sql,$conn);
echo "<table border=1></tr><td>nick<td>clave</tr>";
$count=0;
while ($row=mysql_fetch_array($res)){
echo "<tr><td>{$row[0]}.
<td>{$row[1]}
<td>{$row[2]}
<td>{$row[3]}";
$count++;
}
echo "</table>";
echo "total: $count usuarios";
*/
$sql="SELECT t1.nick , t2.username, t1.titulo ,t2.user_email FROM estadistica as t1, phpbb_users as t2 where t1.accion='clave' and t1.nick=t2.username group by t1.nick";
$res=mysql_query($sql,$conn);
echo "<table border=1></tr><td>nick<td>clave</tr>";
$count=0;
while ($row=mysql_fetch_array($res)){
echo "<tr><td>{$row[0]}.
<td>{$row[1]}
<td>{$row[2]}
<td>{$row[3]}";
$count++;
}
echo "</table>";
echo "total: $count usuarios";
$sql=" SELECT *
FROM `estadistica`
ORDER BY `estadistica`.`id` DESC
LIMIT 0 , 200" ;
$res=mysql_query($sql,$conn);
echo "<table border=1> ";
while ($row=mysql_fetch_array($res)){
echo "<tr><td>{$row[0]}.
<td>{$row[1]}
<td>{$row[2]}
<td>{$row[3]}
<td>{$row[4]}
<td>{$row[5]}
<td>{$row[6]}
<td>{$row[7]}";
}
echo "</table>";
?>
|