if ($_GET[serch0])
{
echo $_GET[serch0];
$sql="SElECT * FROM EmployeeInfo WHERE flag='$inter' AND employeeName='%$_GET[serch0]%' order by 'employeeName'";
echo $sql; //看你这一语句是什么,贴出来
}
{
echo $_GET[serch0];
$sql="SElECT * FROM EmployeeInfo WHERE flag='$inter' AND employeeName='%$_GET[serch0]%' order by 'employeeName'";
echo $sql; //看你这一语句是什么,贴出来
}
$sql="SElECT * FROM EmployeeInfo WHERE flag='$inter' AND employeeName='%{$_GET[serch0]}%' order by employeeName";
SElECT * FROM EmployeeInfo WHERE flag='0' AND employeeName='%1%' order by 'employeeName'
{
echo $_GET[serch0];
$sql="SElECT * FROM EmployeeInfo WHERE flag='$inter' AND employeeName='%$_GET[serch0]%' order by employeeName"; $rs = mysql_query($sql);
...
}
{
echo $_GET[serch0];
$sql="SElECT * FROM EmployeeInfo WHERE flag='$inter' AND employeeName like '%$_GET[serch0]%' order by 'employeeName'";
}