<?php
/******************************************************************************/
/*                                                                            */
/*                       __        ____                                       */
/*                 ___  / /  ___  / __/__  __ _____________ ___               */
/*                / _ \/ _ \/ _ \_\ \/ _ \/ // / __/ __/ -_|_-<               */
/*               / .__/_//_/ .__/___/\___/\_,_/_/  \__/\__/___/               */
/*              /_/       /_/                                                 */
/*                                                                            */
/*                                                                            */
/******************************************************************************/
/*                                                                            */
/* Titre          : Mysql comme PHPMyAdmin                                    */
/*                                                                            */
/* URL            : http://www.phpsources.org/scripts17-MySQL.htm             */
/* Auteur         : Lion                                                      */
/* Date édition   : 03 Oct 2007                                               */
/* Website auteur : http://www.phpsources.org                                 */
/*                                                                            */
/******************************************************************************/


$requete = '...';

mysql_connect('serveur', 'login', 'pass');
mysql_select_db('bdd');

/******************************************************/

$res = mysql_query($requete) or exit(mysql_error());

echo '<table border="1"><tr>';

for ($i = 0; $i < mysql_num_fields($res); $i++) {
    echo '<th>';
    echo mysql_field_name($res, $i);
    echo '</th>';
}

echo '</tr>';

while ($row = mysql_fetch_row($res)) {
    echo '<tr>';
   
    for ($j = 0; $j < count($row); $j++) {
        echo '<td>';
        echo ($row[$j] == NULL) ? '<i>NULL</i>' : $row[$j];
        echo '</td>';
    }
   
    echo '</tr>';
}