[SOLVED] How To Format Height

[refiking]

The height is stored in db as inches only.  How can I display in feet and inches?

 

while ($row = mysql_fetch_assoc($sql)){
$height = $row['height'];
Echo $height . "<br>";
}

[Michdd]

Do you like if it's bigger than 11 inches then display it in terms of inches and feet? Or do you mean show it like:

 

Inches: 24

Feet: 2

 

showing both.

[refiking]

I'd like the output to be this:

//5'11"
//6'2"
//7'0"

[gevans]

imagine 5'11"

 

$height = 71;
$feet = floor($height/12);
$inches = $height%12;
if($feet) echo $feet."'";
if($inches) echo $inches.'"';

[justinh]

<?php

function checkheight($height){

   $feet = $height/12 % 10;
   $inches = $height - $feet*12;
   $height = $feet."'".$inches;

    return $height;
}



  
       



while($row = mysql_fetch_assoc($sql)){

$height = $row['height'];

} 

echo checkheight($height); 

?>