how come this query wont order by date

[kevinkhan]

$select = 'SELECT (YEAR(CURDATE())-YEAR(dateOfBirth)) - (RIGHT(CURDATE(),5)<RIGHT(dateOfBirth,5)) AS age';
  $from = ' FROM profile_list';
  $where = ' WHERE TRUE';
  $order = ' ORDER BY age;';
  
  $sql = $select.$from.$where.$order; 

[PFMaBiSmAd]

how come this query wont order by date

 

Well, you are ordering by age, which is not a date, and you also didn't post any information about what result you are getting and what your expected result should be.

[Simon Mayer]

Well, you are ordering by age, which is not a date, and you also didn't post any information about what result you are getting and what your expected result should be.

 

The above is correct, I suspect you would need to do the following:

 $order = ' ORDER BY `dateOfBirth`;';

 

You would do the following to reverse the order (youngest first):

 $order = ' ORDER BY `dateOfBirth` DESC;';