<?php
$con = mysqli_connect(home.fgx.com.br,"fgxbidper","QajCBPx4W2Zw9U6c","fgx_bidper");
$sql = "SELECT peopleID, firstName, lastName, valueEx FROM exchange inner join people on people.id = exchange.peopleID WHERE curHave = (SELECT CurWant FROM exchange WHERE peopleID = 24) and finished = 0 and peopleID <> 24";
$res = mysqli_query($con,$sql);
$result = array();
while($row = mysqli_fetch_array($res)){
array_push($result,
array('id'=>$row[0],
'curHave'=>$row[1],
'curWant'=>$row[2],
'countryLive'=>$row[3]));
}
echo json_encode(array("result"=>$result));
mysqli_close($con);
?>
preferences:
49.13 ms | 402 KiB | 5 Q