请尝试显示不同的结果从不同的表在数据库到不同的div取决于类型
$fetching_db = "
(SELECT * 'pos' as type FROM `posts` WHERE `title` LIKE '%$keyword%' OR `slug` LIKE '%$keyword%' OR `body` LIKE '%$keyword%' OR `id` LIKE '%$keyword%' ORDER BY `title` DESC)
UNION(SELECT * 'cele' as type FROM `celebrity_news` WHERE `cele_title` LIKE '%$keyword%' OR `cele_slug` LIKE '%$keyword%' OR `cele_body` LIKE '%$keyword%' OR `id` LIKE '%$keyword%' ORDER BY `cele_title` DESC)
UNION(SELECT * 'sog' as type FROM `songs` WHERE `song_name` LIKE '%$keyword%' OR `song_slug` LIKE '%$keyword%' OR `song_desc` LIKE '%$keyword%' OR `id` LIKE '%$keyword%' ORDER BY `song_name` DESC)
UNION(SELECT * 'vid' as type FROM `videos` WHERE `video_name` LIKE '%$keyword%' OR `vide_slug` LIKE '%$keyword%' OR `video_desc` LIKE '%$keyword%' OR `id` LIKE '%$keyword%' ORDER BY `video_name` DESC)
";
尝试使用:
$res = mysql_query($fetching_db);
while($row = mysql_fetch_array($res))
{
echo $row['type'];
}