limit 100
pfrom 2002-05-09
pto 2018-05-06
contains1 Scott Beauchamp
Search Submit
Search Rantburg
'Burg Search
   
"; $ssql="select id,rdate,rbanner from "; $ssql .= "(select * from tbltwar where rdate >= '$pfrom' and rdate <= '$pto') as y "; if($contains1 != ''){ $ssql .= "where lower(rquote) like $contains1 "; } $ssql .= " order by id desc limit $limit"; echo $ssql; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); while($row = pg_fetch_object($result)){ echo "\n"; echo "" . $i++ . ""; echo " id . "\" target=_blank>" . $row->id .""; echo "" . date("m/d/Y",strtotime($row->rdate)) . ""; echo "" . $row->rbanner . ""; echo "\n"; } echo ""; } ?>