PHP trim row results?

Question

Hello I'm getting results in format

location1 2 4
location2 3 2
location3 0 0
location1 1 0

How can I trim results so that row returning 0 and 0 is not displayed ? thank you

.................

Here is Mysql query, I don't know how to trim it from MySQL so I thought using PHP ..

    SELECT hotelas.name, hotelas.address, hotelas.city, hotelas.country, hotelas.hotel_id 
AS hotelid, 
COUNT( DISTINCT apart.apartman_id ) AS number_of_free_ap, 
COUNT( DISTINCT room.apartman_id ) AS num_of_free_rooms
    FROM hotel AS hotelas
    LEFT JOIN apartman AS apart ON ( apart.apartman_hotel = hotelas.hotel_id
    AND apart.occupied =0
    AND apart.what =1 )
    LEFT JOIN apartman AS room ON ( room.apartman_hotel = hotelas.hotel_id
    AND room.occupied =0
    AND room.what =0 )
    GROUP BY hotelas.hotel_id

TABLE field what, 0 - for room, 1 - apartment

So I get a few columns among which the most important ones are count columns , free rooms and free apartments. So I have a test hotel which is full 0 rooms and 0 apartments and I want is removed from this list where all other hotels have at least one room or one apartment available.

Answer 1

select * from table
where column1 !=0
or column2 !=0

That's how you can trim it in MySQL.

OTOH, if you have an array such as this ( you will usually get this after you query from a db)

array(array('location1', 2, 4), array('location2', 3, 2))

Then you need to loop over the array and do the manual filtering:

$newarrs=array();
foreach($arrs as $values)
{
  if($values[1]!=0 || $values[2]!=0)
    $newarrs[]=$values;
}
return $newarrs;

Answer 2

if you are querying you database to get this information and you can change the query, that would be the best place for it.

SELECT *
FROM myTable
WHERE
    firstColumn != 0
OR
    secondColumn != 0

If you are getting this in PHP from some other source (CSV or something), or you don't have control over the query, use array_filter():

// i'm assuming each line in your example is an array of values
$myArray = array_filter($myArray, 'noDoubleZeroes');

function noDoubleZeroes($line) {
    return $line[1] != 0 || $line[2] != 0;
}

Answer 3

If i understood you correctly this should help

$columns = explode($resultLine, " ");
$whatYouWant =  $columns[0];