使用多行作为一个订单

So I have an sql query

所以我有一个SQL查询

$choice = mysqli_real_escape_string($con,$_POST['choice']);

    if($option == "Name")
    $searchresult = "SELECT  id, stationname1, stationinfo1, stationprice1, image1, stationname2, stationinfo2, 
    stationprice2, image2, stationname3, stationinfo3, stationprice3, image3, stationname4, stationinfo4, stationprice4, 
    image4 FROM fuel WHERE stationlocation1 LIKE '%" . $location .  "%' ORDER BY stationname1 $choice"; //search database
$choice