SELECT * FROM abloomberg_animals WHERE 1 ORDER BY id ASC
This page has a PHP script that reads all rows out of a table in the database. We store the rows in an array and then loop through that array (using a foreach loop) and print out each row in the XHTML.
Next to each row are two links "Update" and "Delete". These links have the id of the row attached to the query string in the link. That allows us to pass the id of the row that was clicked to the next page so that it knows which row to update or delete in the database table.
The created date of each row has been beautified to make it more easily human-readable
| 413 | May 21, 2012, 12:50am | Update | Delete |