$dbuser = 'lab'; $dbhost = 'localhost'; $dbpass = ''; $dbname = 'logfiles'; $dbtable = 'protocols'; //------ DATABASE CONNECTION --------// $mysql_link = mysql_connect($dbhost,$dbuser,$dbpass); $column = mysql_list_fields($dbname,$dbtable,$mysql_link); $sql = "SELECT * FROM $dbtable"; $result = mysql_db_query($dbname,$sql); ?>
while($value = mysql_fetch_array($result)) { print "
"; //This loop goes through the colums and prints //each value for($i=0; $i< mysql_num_fields($column); $i++ ) { print "
$value[$i]
"; } print "
"; } mysql_free_result($result); mysql_close(); ?>