Hello.
I posted this at several other discussion forums, and i haven't received any
real way of doing this.
i am about 3/4 done with a article management i am working on and came
across a problem i can't seem to figure out.
On to the question ..
I currently have this query:
$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 ...
Etc, etc.. How would I group them like that. I want to echo the actual day
with all the rows of that day falling under it.
can i do this with one query? Or would i have to create multiple queries?
any examples?
Thanx for any help.
cheers,
- Sebastian
