rendered paste body<?php include 'config.php'; echo('<html><body bgcolor="#92b6c3">'); echo('<font face="arial" size="+4"><center>'); echo("Terra ledendatabase"); echo('</center></font>'); echo('<br><a href="toevoegen.php"><h3>Lid toevoegen</h3></a>'); $bgc = TRUE; $id_link = @mysql_connect($dbhost, $loginname, $loginpass); $tables = mysql_list_tables($dbname, $id_link); $num_tables = mysql_num_rows($tables); // store table names in an array $arr_tablenames[] = ''; // store number of fields per table(index 0,1,2..) in an array $arr_num_fields[] = ''; for ($i=0; $i < $num_tables; $i++) { $arr_tablenames[$i] = mysql_tablename($tables, $i); $arr_num_fields[$i] = mysql_num_fields(mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link)); } // store field names in a multidimensional array: // [i] == table number, [ii] == field number for that table for ($i=0; $i < $num_tables; $i++) { for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); $hash_field_names[$i][$ii] = mysql_field_name($result, $ii); } } for ($i=0; $i < $num_tables; $i++) { //echo("<center><h2>Table $arr_tablenames[$i] </h2></center>"); echo('<br><table align="center" border="1"><tr>'); $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i] ORDER BY achternaam", $id_link); for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { echo("<th>"); echo $hash_field_names[$i][$ii]; echo("</th>"); } echo("</tr>"); $number_of_rows = @mysql_num_rows($result); for ($iii = 0; $iii < $number_of_rows; $iii++) { echo('<tr'); if($iii % 2) echo(' style="background-color: #8aaca3;"'); else echo(' style="background-color: #78ac91;"'); echo('>'); $record = @mysql_fetch_row($result); for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { echo("<td><center>"); echo $record[$ii]; echo("</center></td>"); } echo('<td><a href="wijzigen.php">Wijzigen</a>'); echo('<td><a href="verwijderen.php">Verwijderen</a>'); echo("</tr>"); } echo("</table>"); } echo('</body></html>'); ?>