Examples of ways to display data from a database?

[aaricwon]

I just created a simple form at my work that I want to be a log of the work I do during the day. When I complete an order I type in the order number & any additional info and hit send where it stores in my database along with the time I did the work.

 

How would you suggest displaying the info so people like my boss can see?

 

Can you show me any examples?

 

Aaric

[premiso]

Tables would be the easiest solution:

 

<?php

//Database connection above (assume you know how to do that)

$query = mysql_query("SELECT * FROM table_name ORDER BY datestamp") or die(mysql_error() . "  <--- Error!");

echo '<table><tr><td>Time</td><td>Description</td><td>Order</td></tr>';
while ($row = mysql_fetch_array($query)) {
     echo '<tr>';
     echo '<td>' . $row['datestamp'] . '</td>';
     echo '<td>' . $row['description'] . '</td>';
     echo '<td>' . $row['ordernum'] . '</td>';
     echo '</tr>';
}
echo '</table>';
?>

 

Basic gist of it. Googling can find you much more intuitive already done data grid type scripts.