当前位置: 代码迷 >> PHP >> ,多表模糊搜索后显示的有关问题
  详细解决方案

,多表模糊搜索后显示的有关问题

热度:416   发布时间:2012-02-04 15:43:09.0
求助,多表模糊搜索后显示的问题!
<?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>";
  相关解决方案