/[corp_html]/new.php
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 /new.php

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

revision 1.5 by dpavlin, Fri Feb 23 15:23:32 2001 UTC revision 1.6 by dpavlin, Fri Feb 23 15:42:52 2001 UTC
# Line 50  if (file_exists(find_html_file("news",$m Line 50  if (file_exists(find_html_file("news",$m
50          if (isset($type)) {          if (isset($type)) {
51                  if ($type == "n") {                  if ($type == "n") {
52                          $sql_where .= " and type='n'";                          $sql_where .= " and type='n'";
53                    } elseif ($type == "e") {
54                            $sql_where .= " and type='e'";
55                  }                  }
56          }          }
57    
# Line 64  if (file_exists(find_html_file("news",$m Line 66  if (file_exists(find_html_file("news",$m
66          $sql="select          $sql="select
67                          id,upper(title) as title,town_date,body,more,pdf,                          id,upper(title) as title,town_date,body,more,pdf,
68                          (date-now()::date) as comming                          (date-now()::date) as comming
69                  from news $sql_where order by date desc $sql_limit";                  from news $sql_where order by priority desc,date desc $sql_limit";
70  #       print "$sql";          print "$sql";
71          $sth = $dbh->prepare("$sql");          $sth = $dbh->prepare("$sql");
72          $sth->execute();          $sth->execute();
73          while ($row=$sth->fetchrow_hash()) {          while ($row=$sth->fetchrow_hash()) {

Legend:
Removed from v.1.5  
changed lines
  Added in v.1.6

  ViewVC Help
Powered by ViewVC 1.1.26