"Sebastian" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>[snip]
> $result = $db->sql("SELECT * FROM $news GROUP BY time DESC LIMIT
> $_GET[page], $pagelimit");
> while($row = mysql_fetch_row($result)) {
>
> echo "$row[title] <br/> Written by $row[author] <br/> $row[text]";
> }
>
> I'd like to sort the results by day, example:
>
> Monday's Articles:
> all rows that are posted on Monday.....
>
> Tuesday's Articles:
> all rows that are posted on Tuesday ...
If you're sorting in descending order (as your
query seems to intend), shouldn't it be
Wednesday ... Tuesday ... Monday?
$query =
"SELECT title, author, text, tstamp, DAYNAME(tstamp) AS day "
."FROM news "
."SORT BY tstamp DESC "
."LIMIT {$_GET['page']}, $pagelimit";
$result = $db->sql($query);
$first = true;
$lastday = "";
while($row = mysql_fetch_array($result)) {
if ($row['day'] != $lastday) {
$lastday = $row['day'];
if ($first)
$first = false;
else
echo "</ul>";
echo date("l M j", $row['tstamp']) . "<br/><ul>";
}
echo
"<li><b>{$row['title']}</b><br/>"
."Written by {$row['author']}<br/>"
."{$row['text']}</li>";
}
if ($first)
echo "No results returned!<br/>";
else
echo "</ul>";
In production, I would rewrite this to
separate the logic from the presentation...
but if you trace through it, this should
give you a good idea of how to proceed.
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L++>+++$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t-- 5++ !X R+ tv b++++ DI+++ D-(++) G+ e(++) h-- r- y+
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
