the database has the timestamp in unix format, so this is what i use for
'dayofweek_column' ?
what should $old_dayofweek hold?
thankyou.
cheers,
- Sebastian
----- Original Message -----
From: "John W. Holmes" <[EMAIL PROTECTED]>
| John W. Holmes:
|
| 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...
|
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
