求助,多表模糊搜索后显示的问题!
<?php
$title=htmlspecialchars($_POST["title"]);
$result=mysql_query("select * from pro_trans where title like '%$title%' union select * from pro_transprotection where title like '%$title%' union select * from pro_reactor where title like '%$title%'");
while($row=$db->getarray($result)){
echo "<table width='70%' border='1' cellpadding='0' cellspacing='0' bordercolor='#D8D8D8'>";
echo "<tr>";
echo "<td width='23%' height='20' align='left' valign='middle' class='STYLE4'></td>";
echo "<td align='center' valign='middle' class='STYLE3'><a href='" ?><?php echo talblename; ?><?php echo "?id=$id\'>".$row['title']."</a></td>";
echo "</tr><tr>";
echo "</tr><tr>";
echo "</table>";
}
?>
问大侠,红色的地方怎么写啊?
多表查询后,显示的结果有链接,点击链接进入到相应的页面。
------解决方案--------------------
$result=mysql_query("select *, 'pro_trans' as tbl_name from pro_trans where title like '%$title%' union select *, 'pro_transprotection' as tbl_name from pro_transprotection where title like '%$title%' union select * from pro_reactor where title like '%$title%'");
echo "<td align='center' valign='middle' class='STYLE3'><a href='view.php?tblname=$row[tbl_name]&id=$row[id]'>$row[title]</a></td>";