« What is the best way to structure a meeting database?
How much to charge for creating a database that is highly time consuming? »

How would you return the highest number of a mysql query in PHP?

Say i had a query that was "select email from users". I’ve selected the whole column of "email". How would i return the highest number in that whole field? Is that even possible?

The highest number? I’m not sure I understand what you’re after. Wouldn’t the email field be a text data type, as opposed to a numerical data type?

If for some reason you’ve named a numerical field "email", you could just for SELECT * FROM `users` ORDER BY `email` DESC LIMIT 1; or just SELECT MAX(`email`) FROM `users`;. That would give you the highest value in a numerical column.

This entry was posted on Wednesday, February 3rd, 2010 at 9:30 am and is filed under query. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How would you return the highest number of a mysql query in PHP?”

  1. use the sql MAX command.

    http://www.plus2net.com/sql_tutorial/sql_max.php
    References :

  2. The highest number? I’m not sure I understand what you’re after. Wouldn’t the email field be a text data type, as opposed to a numerical data type?

    If for some reason you’ve named a numerical field "email", you could just for SELECT * FROM `users` ORDER BY `email` DESC LIMIT 1; or just SELECT MAX(`email`) FROM `users`;. That would give you the highest value in a numerical column.
    References :

Leave a Reply