请教sql语句写法?
$sql1是根据用户输入选择值动态生成的:
$conditionsnumber=6;
$conditionsarray=array( $condition1 , $condition2 , $condition3 , $condition4 , $condition5 , $condition6 );
$searchsqlarray=array( where ip= '$condition1 ' , where bianhao= '$condition2 ' , where name= '$condition3 ' , where user= '$condition4 ' , where bankid= '$condition5 ' , where equimode= '$condition6 ' );
for($i=0;$i {
if($conditionsarray[$i]== )
$searchsqlarray[$i]= ;
$havewhere=false;
for($j=0;$j {
$whereposition=strpos($searchsqlarray[$j], where );
if(($whereposition== 1 )&&($havewhere==false))
{
$searchsqlarray[$i]=ereg_replace( where , and ,$searchsqlarray[$i]);
$havewhere=true;
}
}
};
for($i=0;$i
$sql1=$sql1.$searchsqlarray[$i];
$sql = select * from oareport .$sql1. ; ;