查询语句? $sql= sprintf("select * from download where typename='%s' and disptext='%s'",$mtype,$mkey);这样写规范 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我不是为了输出,后面还要用到$sql。....mysql_select_db("download",$mylink); if($mtype!="") { $sql= "select * from download where typename='.$mtype and disptext='.$mkey" ; } else $sql="select * from download"; if($msort!="") { $sql=$sql ."order by". $msort; } else $sql=$sql."order by mtime desc" ; $result = mysql_query($sql,$mylink); $message_count = mysql_num_rows($result);...提示我最后一句不对。 $mylink=mysql_connect("localhost","root",""); mysql_select_db("download",$mylink); if($mtype!="") { $sql= "select * from download where typename='$mtype' and disptext='$mkey'" ; } else $sql="select * from download"; if($msort!="") { $sql.="order by ".$msort; } else $sql.="order by mtime desc" ; $result = mysql_query($sql,$mylink); $message_count = mysql_num_rows($result); 这样就OK啦! $sql= "select * from download where typename like %s".$mtype."%s and disptext like %s".$mkey."%s"; MySQL级联删除问题!!! 请教多表多条件下求和运算 怎么样在Mysql数据库中存储法语? 数据库量很大 请教想实现这种列表如何写SQL... windows上安装postgresql 及EMSmanager2连接简明教程 如何在已经存在的表中增加一个字段????? 请问:怎样把记事本文本文件的数据通过操作phpMyAdmin导入MYSQL数据库? 在局域网内在win2000上用java连linux上的mysql 总是出现错误,急 mysql 的sql语法错误提示能智能一些吗? 求助:关于MySql如何实现与子查询相同的功能!!! VB6能读取MySQL的内容嘛?求助!
....mysql_select_db("download",$mylink);
if($mtype!="")
{
$sql= "select * from download where typename='.$mtype and disptext='.$mkey" ;
}
else $sql="select * from download";
if($msort!="")
{
$sql=$sql ."order by". $msort;
}
else $sql=$sql."order by mtime desc" ;
$result = mysql_query($sql,$mylink);
$message_count = mysql_num_rows($result);
...
提示我最后一句不对。
mysql_select_db("download",$mylink);
if($mtype!="")
{
$sql= "select * from download where typename='$mtype' and disptext='$mkey'" ;
}
else $sql="select * from download";
if($msort!="")
{
$sql.="order by ".$msort;
}
else $sql.="order by mtime desc" ;
$result = mysql_query($sql,$mylink);
$message_count = mysql_num_rows($result);
$sql= "select * from download where typename like %s".$mtype."%s and disptext like %s".$mkey."%s";