送你一个模糊加分类查询的库函数的源码!希望能帮的了你!!! function search_bbs($style_search,$text_search) { global $db; $sql="select id,title,content,writer,importtime from article where "; if($text_search!="") { if($style_search=="title") $sql=$sql. "title like '%$text_search%'"; elseif($style_search=="content") $sql=$sql. "content like '%$text_search%'"; elseif($style_search=="writer") $sql=$sql."writer like '%$text_search%'"; elseif($style_search=="time") $sql=$sql. "importtime like '%$text_search%'"; } $result=mysql_query($sql,$db) or db_error; if($result) return $result; }
select * from tablename where fieldname like '%查找字符串%' 其中%是任意个字符
function search_bbs($style_search,$text_search)
{
global $db;
$sql="select id,title,content,writer,importtime from article where ";
if($text_search!="")
{
if($style_search=="title") $sql=$sql. "title like '%$text_search%'";
elseif($style_search=="content") $sql=$sql. "content like '%$text_search%'";
elseif($style_search=="writer") $sql=$sql."writer like '%$text_search%'";
elseif($style_search=="time") $sql=$sql. "importtime like '%$text_search%'";
}
$result=mysql_query($sql,$db)
or db_error;
if($result) return $result;
}
其中%是任意个字符