Generating Tables from a Database
| From: | Dunaway, Brian | Date: | Thu, 19 Oct 2000 18:57:49 +0000 |
| Subject: | Generating Tables from a Database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-21234@lists.php.net to get a copy of this message | ||
Greetings,
I am working on a project that requires me to pull some data from an oracle
database and place it into a table.
Here is how I would like the output to look based on 3 elements of the
database: Page Name, Day(M-F) and Number of Impressions.
+----------+-----+-----+-----+-----+-----+-----+-----+
|PAGE NAME | Mon | Tue | Wed | Thu | Fri | Sat | Sun |
+----------+-----+-----+-----+-----+-----+-----+-----+
| home | 92| 65| 45| 84| 95| 104| 63|
+----------+-----+-----+-----+-----+-----+-----+-----+
| contact | 32| 26| 12| 34| 31| 65| 21|
+----------+-----+-----+-----+-----+-----+-----+-----+
| products | 65| 45| 75| 96| 22| 93| 64|
+----------+-----+-----+-----+-----+-----+-----+-----+
| services | 75| 62| 43| 67| 75| 91| 75|
+----------+-----+-----+-----+-----+-----+-----+-----+
Currently I am pulling the data into a 3dimensional array and listing the
data through a while loop to create my tables.
Anyone else have experience with this kind of format pulling from a
database? Any pitfalls? Any revelations that would make my job easier like
some example code I could peek at? :)
Thanks
Brian Dunaway