rendered paste body<?php
require "config.php";
mysql_connect($CFG->dbhost, $CFG->dbuser, $CFG->dbpass) or die ('Error connecting to the database');
mysql_select_db($CFG->dbname);
$sql = "SELECT
users.ident id,
users.name name
FROM
{$CFG->prefix}users users,
{$CFG->prefix}user_flags flags
WHERE
users.ident = flags.user_id
AND
flags.flag='admin'
AND
flags.value=1
";
lista_qq_query($sql);
function lista_qq_query($query){
$resultado = @mysql_query($query);
if (!$resultado) {
echo("query error: " . mysql_error() );
exit();
}
echo "<table width=\"100\" border=\"1\">";
echo "<tr bgcolor=\"#A6A6FF\">";
while ($cabecalho = mysql_fetch_field($resultado) ) {
echo "<th>";
echo $cabecalho->name;
echo "</th>";
}
echo "</tr>";
while ( $linha = mysql_fetch_row($resultado) ) {
echo"<tr>";
for ($i=0 ; $i < mysql_num_fields($resultado);$i++ ){
echo "<td>".$linha[$i]."</td>";
}
echo "</tr>";
}
echo"</table>";
mysql_free_result($resultado);
}
?>