maybe you don't have a user-based system, people just enter a few details about themselves

What happens if they've made a few orders, you'd get more than 1 row returned

Anyway, to answer the original question ("how do you know what the value was short of doing another select of the max"), you can't really becase of what I said, which is why you need to think of another way of doing it.