这里有一个SQL查询,返回
因为我使用的是SELECT DISTINCT,所以无法查询其他列
同时,当我使用SELECT*时,没有错误,但会显示重复记录..
下面是我的sql查询
function setvip_sportsbook_model(){
//connect to the server
$conn= mysqli_connect("localhost","root","","people");
//check the connection
if(mysqli_connect_errno($conn)){
echo "Error";
}
else{
//echo "connect Ok";
}
//prepare the sql
$sql= "SELECT DISTINCT merchant_name FROM merchants2";
//execute query
$result= mysqli_query($conn,$sql);
//process result
if($myrow = mysqli_fetch_array($result)){
$record = array();
do{
$info['merchant_name']=$myrow['merchant_name'];
$info['sbvip']=$myrow['sbvip'];
$record[] = $info;
}while($myrow = mysqli_fetch_array($result));
}
return $record;
}
我需要为sbvip做什么查询?非常感谢你