|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
get next events
Hi,
I would like to print next event on my homepage (just title of event) If there are multiple events, I want to print all of them. Next events are not necessary today or tomorrow. Does anybody got an Idee ? Thanks |
|
#2
|
|||
|
|||
|
RE: get next events
There is no answer so I've done it myself.
If it can help somebody here is my source code : <? require_once('agenda/private/ltw_config.php'); $db_connect = mysql_connect($ltw_config['db_server'],$ltw_config['db_user'],$ltw_config['db_pass']); $base_selection = mysql_select_db($ltw_config['db_name'],$db_connect); $query = "SELECT * FROM ltw_eventsv4 WHERE event_date >= CURDATE() ORDER BY event_date"; $req = mysql_query($query); $res = mysql_num_rows($req); $firstdate = ""; $event_list = ""; $multi_event = "false"; $date = ""; if ($res == 0) { echo "<center><b>Sorry there is no result.</b></center>";} else { while($row = mysql_fetch_array($req)) { extract($row); if ($firstdate == "") { $multi_event = "false"; $firstdate = $event_date; $event_list ="<td><b> $name</b><BR>"; if ($location != "") { $event_list .= "Location : $location<BR>";} if ($description != "") { $event_list .= "Description : $description<BR></td>";} $date = date("j m Y",strtotime($row['event_date'])); } else { if ($event_date == $firstdate) { $multi_event = "true"; $event_list .= "<td><b>$name</b><BR>"; if ($location != "") { $event_list .= "Lieu : $location<BR>";} if ($description != "") { $event_list .= "Description : $description<BR></td>";} } } } mysql_free_result($req); } if ($multi_event == "true") { echo "next events on ";echo $date; echo" :<BR> $event_list";} else { echo "Next event on "; echo $date; echo" :<BR> $event_list";} ?> |
|
#3
|
|||
|
|||
|
RE: get next events
Thankyou for posting that snippet it helped me save an awful lot of time, appreciated.
|
![]() |
| Viewing: Codewalkers Forums > Projects > ltwCalendar > get next events |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|