Grouping Rows

[supanoob]

OK, so i want to be able to group multiple rows using the "Date" field and have them in a drop down menu which i will then use along with the user ID field to bring all actions performed on that date by that person, is this possible? if so how?

[Barand]

try

<?php
$res = mysql_query ("SELECT DISTINCT `date` FROM tablename ORDER BY `date` ");

echo "<select name='date'>\n";
while ($row = mysql_fetch_row($res))
{
    $t = strtotime($row[0]);
    printf ("<option value='%s'>%s</option>\n", date('Y-m-d', $t), date('d M y', $t));
}
echo "</select>\n";
?>

[supanoob]

try

<?php
$res = mysql_query ("SELECT DISTINCT `date` FROM tablename ORDER BY `date` ");

echo "<select name='date'>\n";
while ($row = mysql_fetch_row($res))
{
    $t = strtotime($row[0]);
    printf ("<option value='%s'>%s</option>\n", date('Y-m-d', $t), date('d M y', $t));
}
echo "</select>\n";
?>

 

Great thanks