So I have a table in sql. It's basically a inspection report. I've created the form it works great. Submits. Now I want to create a way to call upon an individual report from the table, and display it in a table on php. 
The Below code works perfectly for displaying my information (there is a lot more than 3 colums, just using 3 as an example). The problem is I want to only display one inspection report at time basically, and perhaps even have create a search based on date submitted. The below code is the only way I know how to select ALL the table. 

```
<?php 

$result = mysql_query("SELECT * FROM inspection ORDER BY name");

echo "<table border='1'>
<tr>
<th>ID #</th>
<th>Name</th>
<th>inspection #</th>
</tr>";

while($row = mysql_fetch_array($result))
{
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['Name'] . "</td>";
  echo "<td>" . $row['Inspection #'] . "</td>";
  echo "</tr>";
}
echo "</table>";

?>

```

This works great, just need to know how to better use it for my search. Keep in mind i'm doing this through php for an end user so that he could perhaps just see a page that gives him all dates of inspections and click on the one and it pulls all data and shows up.