events calendar: message for each week's beginning

[anarchoi]

Hi,

 

i'm still trying to build a script that will display the upcomming events from a table (event) containing infos like title ($meuh2) and date infos ($newdate or $dateline for unix-timestamp)

 

here's a part of the code:

 

$query = "SELECT e.*, t.*, p.* FROM event AS e, thread AS t, post AS p  WHERE e.dateline_from > UNIX_TIMESTAMP() AND t.forumid = 16 AND t.threadid = p.threadid AND p.parentid = 0 AND t.title LIKE '$yo' AND t.forumid = '16' AND e.eventid = t.lv_vb_eventforums_eventid ORDER BY e.dateline_from DESC LIMIT $affichage";

 

$res = mysql_query($query) or die(mysql_error()); 

while($row = mysql_fetch_array($res)) {

$dateline = $row["dateline_from"];

$newdate = vbdate($vbulletin->options['dateformat'], $dateline, 0);

}

 

$blah2x = $row["title"];

$meuh2 = substr( $blah2x, 0, 200 );

 

 

echo "<table><tr><td>date: $newdate</td><td> event: $meuh2</td></tr></table>";

 

 

What I would like to do is the following:

at every MONDAY, write between two tables (between two events) something like "EVENTS FOR THIS WEEK: From sunday 3 to saturday 10"

and of course, write this only at the start of a week and not between each event. But, even if a whole month is empty and has no events, it should still display the message for each week

 

thanks for the help!

[Rednarb]

I'm looking for a similar solution - we're you able to get this answered?

 

TIA,

 

Eric

[anarchoi]

not yet... still looking for a solution

[anarchoi]

not yet... still looking for a solution