,多表模糊搜索后显示的有关问题
时间:2021-07-01 10:21:17
帮助过:22人阅读
求助,多表模糊搜索后显示的问题!
$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 "
";
echo "";
echo " | ";
echo "".$row['title']." | ";
echo "
";
echo "
";
echo "
";
}
?>
问大侠,红色的地方怎么写啊?
多表查询后,显示的结果有链接,点击链接进入到相应的页面。
------解决方案--------------------
$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 "
$row[title] | ";