All pastes #1326690 Raw Edit

Mine

public text v1 · immutable
#1326690 ·published 2009-02-03 23:39 UTC
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);
	}

	

?>