Okay so here is the code to make that work... the code I posted originally works for the unordered lists so I had to get a little creative for the table method.
CREATE TABLE `table` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 50 ) NOT NULL ,
`date` DATE NOT NULL DEFAULT '0000-00-00',
UNIQUE (`name`)
);
INSERT INTO `table`
(`name`, `date`)
VALUES
('data1', '2009-10-28'),
('data2', '2009-10-28'),
('data3', '2009-10-28'),
('data4', '2009-10-29'),
('data5', '2009-10-29'),
('data6', '2009-10-29'),
('data7', '2009-10-30'),
('data8', '2009-10-30'),
('data9', '2009-10-30');
<?php
/*********** Database Connection *******************/
// Database access information.
define ('USER', '');
define ('PASSWORD', '');
define ('HOST', '');
define ('DATABASE', '');
// If connection to MySQL works then check to see if the database is selected.
if ($dbc = @mysql_connect (HOST, USER, PASSWORD)) {
// If database could not be selected then write an error message.
if (!mysql_select_db (DATABASE)) {
echo 'Could not select the database';
exit();
}
}
// If the connection to MySQL did not work, print a message to the user, include the footer and kill the script.
else {
echo 'Could not connect to the database.';
exit();
}
/***************************** End of Database Connection File *****************/
// Query.
$q = "SELECT `name`, `date` FROM `table`";
// Query the database to put the values into an array.
$r = @mysql_query ($q);
$results = array();
if (mysql_num_rows ($r) > 0) {
while ($row = mysql_fetch_assoc ($r)) {
$results[] = $row;
}
}
// Start a new arrays.
$records = array();
$table = array();
$columns = array();
// Loop through each of these and place into an array sorted by date if using unorder lists
foreach($results as $r) {
$records[$r['date']][] = $r['name'];
}
// Loop through and make the date the array key if using tables.
foreach ($records as $key=>$value) {
$i=0;
foreach ($value as $k=>$v) {
if (!in_array ($r['date'], $columns)) {
$table[$i][$key] = $v;
}
$i++;
}
}
// Loop through the results to get the the headers into a variable and the data into a variable.
$hdrs = '';
$data = '';
foreach($table as $key=>$value) {
$data .= " <tr>\n";
foreach ($value as $k=>$v) {
if ($key == 0) {
$hdrs .= " <th>" . htmlspecialchars($k) ."</th>\n";
}
$data .= " <td>" . htmlspecialchars ($v) . "</td>\n";
}
$data .= " </tr>\n";
}
$i++;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Pivot</title>
<style type="text/css">
ul {width: 150px; float: left; border: 1px solid black; padding: 0px;}
li {border: 1px solid black; padding: 1px; margin: 2px; list-style-type: none;}
.label, th {font-weight: bold;}
</style>
</head>
<body>
<p>This is the output in Table format:</p>
<table cellpadding="1" cellspacing="2" border="1">
<thead>
<tr>
<?php
echo $hdrs;
?>
</tr>
</thead>
<tbody>
<?php
echo $data;
?>
</tbody>
</table>
<p>This is the output in List format:</p>
<?php
// Loop through this array now since it is an array of just the dates that contains an array of its values. You can add you're own html tags to this.
foreach ($records as $key=>$value) {
echo " <ul>\n" .
" <li class=\"label\">$key</li>\n";
foreach ($value as $v) {
echo " <li>$v</li>\n";
}
echo " </ul>\n";
}
?>
</body>
</html>
:thumbsup: