注册 登录
编程论坛 PHP技术论坛

统计搜索信息的数目问题

kayson 发布于 2007-10-16 18:52, 1308 次点击
对多个数据库表进行模糊搜索
$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(*)统计?
1 回复
#2
可可熊2007-10-16 20:26
count(mysq_query($sql));

1