Generating Tables from a Database

From: 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

« previous php.general (#21234) next »