include('pg_connect.php'); ?> $D = $_GET['D']; if(!isset($D)){ $D=date("Y-m-d"); } else { $D=date("Y-m-d",strtotime($D)); } $ssql = "select count(*) as t from tblcomments where dumptext is not null"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); $crow = pg_fetch_object($result); $TCNT=$crow->t; $ssql = "select count(*) as t from tblcomments where rdate='" . date("Y-m-d",strtotime($D)) ."' and dumptext is not null"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); $crow = pg_fetch_object($result); $DCOUNT=$crow->t; $ssql = "select * from tblcomments where rdate='" . date("Y-m-d",strtotime($D)) ."' and dumptext is not null order by cid desc"; $result = pg_query($ssql) or die ("Error in query: $ssql. " . pg_last_error()); //echo $ssql; ?>
Posted by | Text | Date/Time | IP | |
---|---|---|---|---|
echo $CNTR++; ?> | echo $row->poster ?> | echo $row->comments ?> | echo $row->dtg ?> | echo $row->psource ?> |