PDA

View Full Version : timestamp/while help


sabret00the
09-18-2004, 04:37 PM
i have this query $journal_view = $DB_site->query("
SELECT u.username, e.entryid, e.journalid, e.title, e.entry, e.mood, e.np, e.timestamp, e.userid, e.private, e.displayorder, e.comments
FROM journal_entry e
LEFT JOIN user u ON e.userid = u.userid
WHERE e.private = 0
AND e.journalid = $journalid
AND $postids
ORDER BY e.timestamp DESC
"); however what i'm wondering if whether while i'm dragging these out of the database using a while, i can have em so that anything written on the same data comes under a single date heading where as if it's another day it would add another date heading. i know it'a a while but not quite sure how to do it.

an example of what i'm trying to acheive would be

Sunday 29th June
[entry one on above date @ time]
[entry two on above date @ time]

Friday 27th June
[entry one on above date @ time]

Monday 23rd June
[entry one on above date @ time]
[entry two on above date @ time]

Sunday 22nd June
[entry one on above date @ time]

i'm not very good at time stamps i'm afraid :(

and heres the while i'm currently using to display the data
while ($journal = $DB_site->fetch_array($journal_view))
{
$entrydate = vbdate($vboptions['dateformat'], $journal[timestamp]);
$entrytime = vbdate($vboptions['timeformat'], $journal[timestamp]);
$journal[description] = parse_bbcode($journal[entry]);
$journal[description] = stripslashes($journal[description]);

if($journal[private]==1)
{
$privatecountposts = $privatecountposts-1;
$countposts = "p" . $privatecountposts;
$entrystatus = "[Private Entry #$privatecountposts]";
$bordercolor = "#D2698B"; // SHOULD BE CHANGED
}
else
{
$countposts = $pubcount--;
$entrystatus = "[Entry #$countposts]";
$bordercolor = "{tableheadbgcolor}";
}

$journal[title] = stripslashes($journal[title]);
$journal[description] = html_entity_decode($journal[description]);
$journal[mood] = stripslashes($journal[mood]);
$journal[np] = stripslashes($journal[np]);

eval('$entrybits .= "' . fetch_template('journal_entrybits') . '";');
}

Natch
09-20-2004, 12:29 AM
Take a look at that caching trick, then try caching a couple of levels .... $array[$journal_view[journalid]][$daystamp] = $journal_viewIf you cut the timestamp back to have a unique timestamp once a day $daystamp = gmtime(12, 0, 0, date("m",$timestamp), date("d",$timestamp), date("Y",$timestamp))