#list($usec, $sec) = explode(' ', microtime());
#mt_srand((float) $sec + ((float) $usec * 10000));
#mt_srand((double)1000000.0*microtime());
$c=pg_connect("dbname=yosedb user=yoseuser");
$q="select distinct on (thread) * from yose5_messages order by thread desc, message_id desc;";
$d=pg_exec($c,$q);
$cnt=pg_numrows($d);
for ($i=0;$i<$cnt;$i++) {
$row=pg_fetch_array($d,$i,PGSQL_ASSOC);
$l="http://yosemitenews.info/ylink/";
$l.=$row['message_id']."/".$row['thread'];
printf("%d. %s %s \n", $row['thread'],$l,trim($row['subject']), $row['author']); } pg_freeresult($d); ?> |
[Yosemite News] [Yosemite Photography] [Yosemite Books] [DVD Store]