not sure how to display "age"

[harkly]

I would like to use this code to calculate ages.

 

SELECT name, birth, CURDATE(),
  (YEAR(CURDATE())-YEAR(birth))
  (RIGHT(CURDATE(),5)<RIGHT(birth,5))
  AS age
  FROM pet;

 

I got it from http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html and can get it to work in the mysql command line but I have no idea how to display "age" on my webpage.

 

This is my code

 

        $result = mysql_query("SELECT

          userID,
          birth_date,
          CURDATE(),
          (YEAR(CURDATE())-YEAR(birth_date)) - (RIGHT(CURDATE(),5)<RIGHT(birth_date,5))
          AS age FROM user WHERE userID = 'kelly'") or die(mysql_error());

          while ($r=mysql_fetch_array($result))
            {

              $userID=$r['userID'];
              $birth_date=$r['birth_date'];

            }

            echo " 
            \n";
      ?>

 

Can anyone help?

 

[harkly]

figured it out!!