List all the data in a table

[white_ghost]

Is there a way to list all the data in a table?
So when I insert data into the table it will atumaticlly update itself? I know you can just use SELECT * FROM test_table but how do you list all of the data?

[drew010]

$query = "SELECT * FROM test_table";
$result = mysql_query($query);

echo "<table border=1 align=center cellpadding=3 cellspacing=0>";

while($data = mysql_fetch_array($result)) {
echo "<tr>";
foreach($data as $one_field) {
echo "<td>$one_field</td>";
}
echo "</tr>\n";
}
echo "</table>";

that should list all data in a table.

[white_ghost]

🙁 For some reason when i use the code it duplicates each item, why?:mad:

[drew010]

i tried to use a shortcut and use a foreach to show each field in yoru table because i dont know them.. but if you have a table with a structure like this:
id data1 data2 data3

then just have it
echo "$data[id] - $data[data1] - $data[data2] - $data[data3]<br>";

that will fix the duplication problem.