@DanJacobs: "$query = "SELECT * FROM `names` ORDER BY `age` DESC;";
echo "<table border =\"1\">";
while ( $row = $result->fetch_assoc() ) {
    echo "<tr><th>#</th><th>Name</th><th>Age</th></tr>";
echo "<tr>";
    echo "<td>{$row['name']}</td><td> {$row['age']}</td>";
echo "</tr>\n";
}
echo "</table>";
This much works exactly as I want. However, I want to list names that are 
above a certain age. What's the best way to do this?"
    @noreply: "<quote>
Why do you always nitpick on stuff you know nothing about?
How do you know he does not have a date of birth column?
At this point, he's only interested in knowing how to show the data the way
he wants.
You should learn to "KISS" more.
Keep it simple, stupid!"
    @jstucklex: "<quote>
If he had a date of birth column, he wouldn't be asking for "age > 21". 
  And if he also had a date of birth column, he would be violating the 
first rule of normalization.  Either way complicates matters more (not 
that you would understand).
Yup, KISS means a date of birth column.  It solves a whole lot of problems.
However, you once again show why your are called RTS.
==================
Remove the "x" from my email address
Jerry Stuckle
<email_address>
=================="
    @jurgenex: "On Wed, 28 May 2014 14:09:14 -0500, <email_address> (Gordon
Burditt) wrote in comp.databases.mysql:
<quote>
Apparently yes, because that's what the OP asked for.
Well, that would depend very much on the jurisdiction. In most countries
21 is only of relevance for rather obscure items like driving licenses
for busses or dangerous cargo or Aircraft Transport Pilot certificate.
jue"
    @gordonb9aipm: "<quote>
Then you use the appropriate number in the call to DATE_ADD().  You
can use a variable if you like also.  There is no need to store the
result of the DATE_ADD() in the table.
The OP is certainly not working for the government.  At least I sure
hope not.  
If it's a volunteer organization, or a charity, I can avoid giving them
any money or free labor, so they may want to be a little more tactful
about privacy invasions.  The same applies to online stores.
For some web sites, if you claim to be a child, you can't use a
credit card to order anything, or you can't order anything, period.
The whole reason they ask for age may be (a) is this person old enough
to use a credit card? and (b) is this person old enough to buy porn?
That tends to be more your problem than theirs.  I suppose the NY
Times doesn't have any X-rated sections.
If he wants to select records based on age, it just might matter
to him getting the age right.  Especially if it means a jail term
for selling adult material to minors.
If he asks a question with insufficient information, he'll get back 
either a lot of questions requesting more details (which he may not
understand), or answers based on reasonable assumptions for what
he wants (and some of these assumptions will be wrong).
Therefore, to answer his question, we need to ask or guess to provide an answer.
Perhaps he thinks that's what his query does, but if age is an integer
column, it won't.  
In order to calculate age to that many decimal places, you'll need to 
provide the time zone of birth and the time zone of where you are now.
(How's that for ridiculous nitpicking?  )  Oh, and we might have to worry
about leap seconds.
About the only simple response anyone could give would be "You did
not give enough details for an answer"."
    @jstucklex: "<quote>
Evan, you just don't understand.  The comment are way beyond Richard's 
understanding, which means you shouldn't confuse the OP with them.
==================
Remove the "x" from my email address
Jerry Stuckle
<email_address>
=================="
{'source': 'USENET', 'other_information': '{"reply_count": 5, "forum_name": "comp.databases.mysql.20150609.mbox"}', 'file': 'data/output/usenet-comp.databases.parquet'}