根据几个字段生成SQL语句 有如下图的数据表信息,有什么好的方法把它们组合成一条SQL? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $sql = "select * from talbe where cvid=58 and columnname!=''";$query = mysql_query($sql);$out = '';while($row = mysql_fetch_assoc($query)){ $out .=$row['columnname'].'='.$row['value'].' '.$row['andor'].' '}$out = "select * from table".$out;echo $out ; $sql = "select * from talbe where cvid=58 and columnname!=''";$query = mysql_query($sql);$out = '';while($row = mysql_fetch_assoc($query)){ $fh = $row['comparator']; $fh == 'eq' ? $fh = '=' : '' ; !empty($row['andor']) ? $andor = $row['andor'] : $andor = '' ; $out .=($row['columnname'].$fh.$row['value'].') '.$andor.' ' ;}$out = "select * from table where ".$out ;echo $out ; 正则 只能输入0-20的问题 php5 使用Session存取对象 php里面 button 怎么传值? 读取MySQL表中数据出错 PHP读文件出错 [[紧急]]phpadmin和Mysql的讨厌问题 php的动态页面怎样自动转换为静态页面的输出? foreach的用法?? 请大虾帮我看看 CSDN的分涨的蛮快嘛! 求一个大文件上传源码 急求
$sql = "select * from talbe where cvid=58 and columnname!=''";
$query = mysql_query($sql);
$out = '';
while($row = mysql_fetch_assoc($query)){
$out .=$row['columnname'].'='.$row['value'].' '.$row['andor'].' '
}
$out = "select * from table".$out;
echo $out ;
$sql = "select * from talbe where cvid=58 and columnname!=''";
$query = mysql_query($sql);
$out = '';
while($row = mysql_fetch_assoc($query)){
$fh = $row['comparator'];
$fh == 'eq' ? $fh = '=' : '' ;
!empty($row['andor']) ? $andor = $row['andor'] : $andor = '' ;
$out .=($row['columnname'].$fh.$row['value'].') '.$andor.' ' ;
}
$out = "select * from table where ".$out ;
echo $out ;