$result = mysql_query("SELECT * FROM
intoput
WHERE (if($getmt201!=0)
nampc LIKE '%$getmt201%')
AND
======
MYSQL好象报错
intoput
WHERE (if($getmt201!=0)
nampc LIKE '%$getmt201%')
AND
======
MYSQL好象报错
解决方案 »
- 请问mysql-bin.000001这类文件能删除吗?
- 更新一个text字段也能这么慢,很诡异!
- 数据量太大
- postgres建立周期任务
- 如何用 share storage 来做 MySQL 的 cluster 环境呢?
- 查找某一记录的上一条记录或下一条记录该如何写?
- ???NOT NULL咋不生效???
- 还是两表查询问题 union all 为什么只能取到其中的前面的而后没有,求大侠指点。
- 怎么才能批量修改呢?
- myql客户端正在执行mysql_query时,断开网络,出现阻塞
- 有没有命令修改MySQL的日期的格式的?
- MySQL安装后出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket
$result = mysql_query("SELECT * FROM `intoput` WHERE `{$getmt201}` <> 0 AND `nampc` LIKE '%{$getmt201}%'");
有时可能是空
不管
非空时
nampc LIKE '%$getmt201%'
作为条件
if (strlen($getmt201) > ) $SQL .= "`nampc` LIKE '%{$getmt201}%'";
$SQL .= 'AND ...';
$result = mysql_query($SQL);
出现了以上错误
不知错在哪儿
<?php$con = mysql_connect("localhost","root","122609louis");if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$ccds201=$_GET["ma"];
$getmt201=iconv("gb2312","UTF-8",$ccds201);
$getmt202=$_GET["mb"]; $getmt203=$_GET["mc"];
$getmt204=$_GET["md"];$ccds205=$_GET["me"];$getmt205=iconv("gb2312","UTF-8",$ccds205);$ccds206=$_GET["mf"];$getmt206=iconv("gb2312","UTF-8",$ccds206);
$ccds207=$_GET["mg"];$getmt207=iconv("gb2312","UTF-8",$ccds207);
$ccds208=$_GET["mh"];$getmt208=iconv("gb2312","UTF-8",$ccds208);
$getmt209=$_GET["mi"];
//时间被必赋值
$getmt210=$_GET["mj"];
if ($getmt210=="")
{$getmt210="1990-01-01";}
$getmt211=$_GET["mk"];
if ($getmt211=="")
{$getmt211="2990-01-01";} $ccds212=$_GET["ml"];$getmt212=iconv("gb2312","UTF-8",$ccds212);
$ccds213=$_GET["mm"]; $getmt213=iconv("gb2312","UTF-8",$ccds213);echo $getmt201,$getmt202,$getmt203,$getmt204,$getmt205,$getmt206,$getmt207,$getmt208,$getmt209,$getmt210,$getmt211,$getmt212,$getmt213;
mysql_select_db("jsp_db", $con);$SQL = "SELECT * FROM intoput WHERE";
if (strlen($getmt201) >0 ){
$SQL.= " nampc LIKE '%$getmt201%'";
$SQL.= "AND";}
if (strlen($getmt202) >0) {
$SQL.= "namhs LIKE '%$getmt202%'";
$SQL.= "AND";}
if (strlen($getmt205) >0 ) {
$SQL.= "gclass_1a LIKE '%$getmt205%'";
$SQL.= "AND";}
if (strlen($getmt206) >0 ){
$SQL.= "gclass_2a LIKE '%$getmt206%'";
$SQL.="AND";}
if (strlen($getmt207) >0 ) {
$SQL.= "gclass_3a LIKE '%$getmt207%'";
$SQL.= "AND";}
if (strlen($getmt208) >0){
$SQL.= "beizpc LIKE '%$getmt208%'";
$SQL.= "AND";}
if (strlen($getmt209) >0 ) {
$SQL.= "jiangu LIKE '%$getmt209%'";
$SQL.= "AND";}
if (strlen($getmt212) >0 ) {
$SQL.= "namein LIKE '%$getmt212%'";
$SQL.= "AND";}
if (strlen($getmt213) >0 )
$SQL.= "unitpc LIKE '%$getmt213%'";
$result = mysql_query($SQL)or die(mysql_error());