$dbuser = 'user'; $dbhost = 'localhost'; $dbpass = 'password'; $dbname = 'dbname'; $dbtable = 'tablename'; //------ 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(); ?>