getMessage() . "
"; } $conn->exec("SET CHARACTER SET utf8"); $sql="select a.id,user_id,blog_id,a.date,a.num_reads,b.article_id,b.topic from lt_articles as a,lt_articles_text as b where a.id=b.article_id " . $aps . "order by a.id desc;"; $result=$conn->query($sql); echo "After Excute $sql
\n"; $rowcount=$result->rowCount(); printf("計 %d 筆資料!\n",$rowcount); echo "
編號 主題 發表時間 人次 \n"; while($row=$result->fetch()){ echo "
" . $row['article_id'] . "" . "" .$row['topic'] . "" . "" . $row['date'] . " " . $row['num_reads'] . "次"; } echo "
\n"; $conn=NULL; ?>