vb.org Archive - date blues

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - date blues (https://vborg.vbsupport.ru/showthread.php?t=55421)

Gary King

07-24-2003 06:26 PM

Looks fine to me.

Could you point out which one is incorrect?

Dave#

07-24-2003 06:39 PM

Quote:

Today at 08:26 PM Gary W said this in Post #11
Looks fine to me.

Could you point out which one is incorrect?

the last one for example

Friday 9th May Coventry (A)

Should say Sunday, I think all the days are wrong in 2004

Dave#

07-27-2003 10:43 PM

did you manage to have a look at this Gary ?

Gary King

07-27-2003 11:56 PM

Sorry, didn't know there was a new reply :o

Here's the answer :)

PHP Code:


		
			
<?php



require('../global.php');



$events = $DB_site->query("SELECT event, eventdate AS date, eventdate, eventid, subject

                           FROM calendar_events

                           WHERE public = 1 AND eventdate >= NOW()

                           ORDER BY eventdate LIMIT 8");

if ($DB_site->num_rows($events)) {

  echo "<ul>";

  while ($event = $DB_site->fetch_array($events)) {

        $timestring=strtotime($event['date']);

        $date=date("l jS F",$timestring);

    echo "<li><font size=\"1\">".$date." <a

href='calendar.php?s=$session[sessionhash]&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a> <br>

        ";

  }

} else {

  echo "No Events";

}

echo "</ul>";

?>

Dave#

07-28-2003 07:06 AM

Quote:

Today at 01:56 AM Gary W said this in Post #14
Sorry, didn't know there was a new reply :o

Here's the answer :)

PHP Code:

<?php require('../global.php'); $events = $DB_site->query("SELECT event, eventdate AS date, eventdate, eventid, subject FROM calendar_events WHERE public = 1 AND eventdate >= NOW() ORDER BY eventdate LIMIT 8"); if ($DB_site->num_rows($events)) { echo "<ul>"; while ($event = $DB_site->fetch_array($events)) { $timestring=strtotime($event['date']); $date=date("l jS F",$timestring); echo "<li><font size=\"1\">".$date." <a href='calendar.php?s=$session[sessionhash]&action=getinfo&eventid=".$event['eventid']."'>".$event['subject']."</a> <br> "; } } else { echo "No Events"; } echo "</ul>"; ?>

excellent - thanks a million Gary

Gary King

07-28-2003 03:21 PM

Yep glad I could help :)

All times are GMT. The time now is 02:55 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01041 seconds Memory Usage 1,752KB 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 (2)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (6)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: