Thanks for that. Can get the tables listed fine but experiencing problems with displaying the actual data. I've tried putting the display loop inside the while ($row....) loop and outside.
while(list($tbl) = each($tbls))
$result = mysql_query("SELECT `info1`, `info2` FROM `$tbl`");
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
$data = $row
/* PUT LOOP HERE ?? */
I get the error:
Warning: Variable passed to each() is not an array or object in multitables3.php, with the line referring to the while (list($tbl) = each($tbls)) line.
Would I be correct in thinking that all the data is read into the $data array and then can be simply displayed using the using method of:
while ($a_row = mysql_fetch_row($data))
foreach ($a_row as $field)
This works fine when reading from a single table. Apologies for what is probably an easy answer but I'm still very new to all this.