麻烦帮忙检查一下该语句有何错误
aqiu 2003-08-19 01:38:39 php function list_review($tid,$setid){
global $dbhost,$dbuser,$dbpasswd,$dbname,$news_table,$review_table;
global $list_num,$datetxt;
if ($tid>"0" && $tid<"999999999"):
$istid = "&& newsid=$tid";
else:
$tid = 0;
$istid = "";
endif;
$sql = "SELECT COUNT(*) AS rcnt FROM $review_table $istid ORDER BY id DESC";
$result = mysql_db_query($dbname, $sql);
$row = mysql_fetch_array($result);
$num = $row[rcnt];
$num = $row[rcnt];
if ($num <= 0):
echo "<center>未找到任何记录<br><br>";
endif;
if (empty($setid)):
$setid = 0;
endif;
$sql = "SELECT * FROM $review_table $istid ORDER BY id DESC LIMIT $setid, $list_num";
$result = mysql_db_query($dbname, $sql);
while ($row=mysql_fetch_array($result))
{
// 获取新闻标题
$news_sql = "SELECT * FROM $news_table WHERE id='$row[newsid]'";
$news_result = mysql_db_query($dbname, $news_sql);
$objresult = mysql_fetch_object($news_result);
$newsname = $objresult->title;
// 显示列表记录
echo "<table border=0 cellpadding=3 cellspacing=0 width=100%>\n";
echo "<tr>\n";
echo "<td width=75%>[<a href=\"review.php?tid=$row[newsid]\">$newsname</a>] \n";
echo "[$row[newsid]]";
echo "$row[text]\n";
$date = date($datetxt,$row[date]);
echo "<font color=#c0c0c0> $date</font>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
}
}
目的是想以$row[newsid]为关键字对$newsname进行归类
如review.php?tid=4
但实际上却没起到任何作用
求解