![]() |
#2
可可熊2007-10-16 20:26
|
对多个数据库表进行模糊搜索
$sql=" SELECT * FROM `php` WHERE `title` LIKE '%$keyword%'
union all SELECT * FROM `html` WHERE `title` LIKE '%$keyword%'
union all SELECT * FROM `css` WHERE `title` LIKE '%$keyword%'
union all SELECT * FROM `load` WHERE `title` LIKE '%$keyword%'
union all SELECT * FROM `java` WHERE `title` LIKE '%$keyword%'
union all SELECT * FROM `specific` WHERE `title` LIKE '%$keyword%' ";
但是怎么样统计搜索出来信息的条数呀?怎么用count(*)统计?