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]";
Probably a typo, but fetch_row() will not give you $row['title'], $row['text'], etc... fetch_array() and fetch_assoc() will, though. More below...
}
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?
You only need one query. One of your columns should be what you want to "change" on, like DAYOFWEEK(date_column). As you loop through your rows, you echo out your "heading" whenever this column changes...
while($row = mysql_fetch_assoc($result))
{
if($row['dayofweek_column'] != $old_dayofweek)
{
echo "<tr><th>{$row['dayofweek_column']}'s Columns</th></tr>";
$old_dayofweek = $row['dayofweek_column'];
}
echo "$row[title] <br/> Written by $row[author] <br/> $row[text]";
}Untested, but something like that. :)
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
PHP|Architect: A magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
