we are making the script after u execut the query:
/* we grap the results like this */
$output = array();
/* in $resource should be your mysql resource after executing your query */
while ($rez=mysql_fetch_assoc($resource)) {
if (empty($output[$rez['date']])) $output[$rez['date']] = $rez['item']."\r\n";
else $output[$rez['date']].= $rez['item']."\r\n";
}
/* here u should see your output and echo like u want */
echo "<pre>",print_r($output,1),"</pre>";
if u want to do this all from mysql u should check GROUP BY with CONCAT..
