/[pliva-si]/inc/common.inc
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /inc/common.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.3 by dpavlin, Fri Jun 29 08:33:59 2001 UTC revision 1.4 by dpavlin, Fri Jun 29 12:55:11 2001 UTC
# Line 14  $smarty->assign("menu",$menu); Line 14  $smarty->assign("menu",$menu);
14    
15  // fetch news  // fetch news
16    
17  $sth = $dbh->prepare("select id,title from news where type<>'e' and type<>'p' and visible order by date desc limit 5");  $sth = $dbh->prepare("select id,title from news where substr(type,1,1)='n' and visible order by date desc limit 5");
18  $sth->execute();  $sth->execute();
19  while ($row=$sth->fetchrow_hash()) {  while ($row=$sth->fetchrow_hash()) {
20          $news[]=$row;          $news[]=$row;
21  }  }
22  $smarty->assign("news",$news);  $smarty->assign("news",$news);
23    
24  $sth = $dbh->prepare("select id,title from news where type='e' and visible order by priority desc,date desc limit 5");  $sth = $dbh->prepare("select id,title from news where substr(type,1,1)='e' and visible order by priority desc,date desc limit 5");
25  $sth->execute();  $sth->execute();
26  while ($row=$sth->fetchrow_hash()) {  while ($row=$sth->fetchrow_hash()) {
27          $events[]=$row;          $events[]=$row;
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.26