if(isset($_POST['submitted']))
{
$KeyWord=$_GET['keyword'];
$KeyWord=trim($KeyWord);
$show='select * from message where user like \"%".$KeyWord."%\" ';
$sql=mysql_query($show);
$num=mysql_num_rows($sql); if($num>0)
{
$number=$num;
}
else
{
$show='select * from message where subit like \"%".$KeyWord."%\" ';
$sql=mysql_query($show);
$num1=mysql_num_rows($sql);
if($num1>0)
{
$number=$num1;
}
else
{
$show='select * from message where contents like \"%".$KeyWord."%\" ';
$sql=mysql_query($show);
$num2=mysql_num_rows($sql);
if($num2>0)
{
$number=$num2;
}
else
{
$str='没有找到相关信息!';
$script="<script type='text/javascript'>alert('$str');</script>";
echo $script;
echo "<script> window.location = 'search.php'; </script> ";
}
}
}
}我的用意是当搜索时,当没找到用户user时~转成搜索标题subit,else在搜索内容contents,最后就是什么都没找到。但是还是报错了~请高人指点下
{
$KeyWord=$_GET['keyword'];
$KeyWord=trim($KeyWord);
$show='select * from message where user like \"%".$KeyWord."%\" ';
$sql=mysql_query($show);
$num=mysql_num_rows($sql); if($num>0)
{
$number=$num;
}
else
{
$show='select * from message where subit like \"%".$KeyWord."%\" ';
$sql=mysql_query($show);
$num1=mysql_num_rows($sql);
if($num1>0)
{
$number=$num1;
}
else
{
$show='select * from message where contents like \"%".$KeyWord."%\" ';
$sql=mysql_query($show);
$num2=mysql_num_rows($sql);
if($num2>0)
{
$number=$num2;
}
else
{
$str='没有找到相关信息!';
$script="<script type='text/javascript'>alert('$str');</script>";
echo $script;
echo "<script> window.location = 'search.php'; </script> ";
}
}
}
}我的用意是当搜索时,当没找到用户user时~转成搜索标题subit,else在搜索内容contents,最后就是什么都没找到。但是还是报错了~请高人指点下
"select * from message where contents like '%".$KeyWord."%'";
$t = '123';
echo '$t';
echo "$t";//你测试下,这两者是不一样的单单语句,1#是可执行的,为了更明显,特别分开写了,你可以换写法,,是否符合你的逻辑,就不知道了