Hello what im looking for here is to get the next addition in the database to drop below the first set of tables. at the moment it is only showing the last persons submission it does create the tables with the data but with only the last persons.
when the next person submits data it will show it in the tables but wont show the prior submissions. I hope I explained this ok...lol
Example:
user 1 data input
user 2 data input
user 3 data input
into the tables below.
<?php
mysql_connect("localhost", "Name", "Pass") or die(mysql_error());
mysql_select_db("DB") or die(mysql_error());
$result = mysql_query("SELECT * FROM my_form_1");
$row = mysql_fetch_array ($result);
echo "<table border='1'>
<tr>
<th>CITY</th>
<th>STREET</th>
<th>RESPONDER</th>
<th>DISCRIPTION</th>
<th>TYPE OF CALL</th>
<th>DATE</th>
<th>TIME</th>
</tr>";
{
echo "<tr>";
echo "<td>" . $row['element_1'] . "</td>";
echo "<td>" . $row['element_2'] . "</td>";
echo "<td>" . $row['element_3'] . "</td>";
echo "<td>" . $row['element_4'] . "</td>";
echo "<td>" . $row['element_5'] . "</td>";
echo "<td>" . $row['element_6'] . "</td>";
echo "<td>" . $row['element_7'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>