php - How to do this multiple IF statement in MySQL -

i have table:

scanner name | maxwidth | maxlength ==================================== scanner    | 50       | 100 scanner b    | 60       | 120 

in php have:

$paperw = 70; $paperl = 55; 

how mysql query result return:

scanner name ============ scanner b 

the idea find scanner fits paper size. although paper width 70 , length 55, , printer b have max width of 60, can rotate paper orientation paper width becomes 55 , length becomes 70 fit scanner b.

in pseudo-code check if scanner fits paper this:

if (paperw <= maxwidth && paperl <= maxlength)  return true else{  if (paperw >  maxwidth){     if (paperw <= maxlength && paperl <= maxwidth)        return true;     else        return false;  }  else   return false; } 

i have no idea transalte mysql query.. appreciated.

just rectangle area in php.

rectarea = width * length; 

and use rectarea in clause.

 select       scanner_name,      max_width,      max_length,      (max_width * max_length) page_area   scanners     (max_width * max_length)  >=  rectarea ;