提问者:小点点

如何根据sql查询结果的类型在不同的div中显示sql结果[关闭]


请尝试显示不同的结果从不同的表在数据库到不同的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)
        ";

共1个答案

匿名用户

尝试使用:

$res = mysql_query($fetching_db);
while($row = mysql_fetch_array($res))
{
    echo $row['type'];
}