Re: [PHP] rows by day

2003-06-15 Thread Sebastian
- Original Message - From: "John W. Holmes" | John W. Holmes wrote: | | 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... | | whil

Re: [PHP] rows by day

2003-06-15 Thread Sebastian
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 column

Re: [PHP] rows by day

2003-06-15 Thread John W. Holmes
Sebastian wrote: 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

[PHP] rows by day

2003-06-15 Thread Sebastian
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("S