vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   timestamp/while help (https://vborg.vbsupport.ru/showthread.php?t=69595)

sabret00the 09-18-2004 04:37 PM
timestamp/while help
 
i have this query
PHP Code:
        $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
PHP Code:
        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 ....
Code:
$array[$journal_view[journalid]][$daystamp] = $journal_view
If you cut the timestamp back to have a unique timestamp once a day
PHP Code:
$daystamp = gmtime(12, 0, 0, date("m",$timestamp), date("d",$timestamp), date("Y",$timestamp)) 


All times are GMT. The time now is 11:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01113 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete