欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

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

程序员文章站 2022-05-22 08:30:04
...
求助,多表模糊搜索后显示的问题!
$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 "";
echo "";
echo "";
echo "
".$row['title']."
";
}
?>


问大侠,红色的地方怎么写啊?
多表查询后,显示的结果有链接,点击链接进入到相应的页面。

------解决方案--------------------
$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 "