,多表模糊搜索后显示的有关问题
程序员文章站
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 "";
";
}
?>
问大侠,红色的地方怎么写啊?
多表查询后,显示的结果有链接,点击链接进入到相应的页面。
------解决方案--------------------
$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 "
$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 "
"; | ".$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 "
上一篇: 第一章 SQL Server数据库基础