| |
|
|
| |
EVENTS
SQL: ' . $query);
$article = mysql_fetch_assoc($rs);
// if there are no articles archived else display articles archived
if(mysql_num_rows($rs)<=0){
echo 'No News Articles!
';
}else{
// output more headlines
do{
echo sprintf('%s
',$PHP_SELF,$article['calid'],$article['headline']);
echo sprintf('%s
',date('r',strtotime($article['calendardate'])));
echo sprintf('%s
',$article['summary']);
}while($article = mysql_fetch_assoc($rs));
}
// end
}
?>
SQL: ' . $query);
$article = mysql_fetch_assoc($rs);
// if there are no articles archived else display articles archived
if(mysql_num_rows($rs)<=0){
echo 'No Archived Articles!
';
}else{
// output archived articles
do{
echo sprintf('%s:- ',date('r',strtotime($article['calendardate'])));
echo sprintf('%s
',$PHP_SELF,$article['calid'],$article['headline']);
}while($article = mysql_fetch_assoc($rs));
}
}
// end
?>
|
|
| |
 |
|
|
|
|
| |
|
|
| |
SQL: ' . $query);
// output article
$headline = mysql_result($rs,0,"headline");
$date = date('r',strtotime(mysql_result($rs,0,"calendardate")));
$article_details = mysql_result($rs,0,"details");
?>
'.$date.'
'.$article_details; // output article ?>
SQL: ' . $query);
$article = mysql_fetch_assoc($rs);
// if there are no articles archived else display articles archived
if(mysql_num_rows($rs)<=0){
echo 'No News Articles!
';
}else{
// output all articles
echo 'News Articles:-
';
do{
echo sprintf('%s
',$PHP_SELF,$article['calid'],$article['headline']);
echo sprintf('%s
',date('r',strtotime($article['calendardate'])));
echo sprintf('%s
',$article['summary']);
}while($article = mysql_fetch_assoc($rs));
}
// list the archived news
// query
$query = "SELECT * FROM calendar_schedule WHERE position = 'archive' ORDER BY calendardate DESC"; // list all articles that are tagged as 'archive'
// query database
$rs = phpmkr_query($query,$conn) or die("Failed to execute query: " . phpmkr_error() . '
SQL: ' . $query);
$article = mysql_fetch_assoc($rs);
// if there are no articles archived else display articles archived
if(mysql_num_rows($rs)<=0){
echo '
No Archived Articles!
';
}else{
// output archived news
echo '
Archived News Articles:-
';
do{
echo sprintf('%s:-',date('r',strtotime($article['calendardate'])));
echo sprintf('%s
',$PHP_SELF,$article['calid'],$article['headline']);
}while($article = mysql_fetch_assoc($rs));
}
}
?>
|
|
|
