Simple DB Query Needed

[ecopetition]

Hi,

 

I'm looking for a query that will let me check different rows of a database to see which one has the highest time (a time_posted column is present). I also need to set conditions.

 

Something like:

$sql = SELECT *

        FROM tablename

        WHERE post_number = $post_number

        AND time_posted = {{{highest number}}}

$result = $resultvar[]

 

What would I set {{{highest number}}} to?

[obsidian]

You cannot have aggregates in your where clause that way, but you can sort on the time_posted column and limit to one:

SELECT * FROM tablename WHERE post_number = $post_number ORDER BY time_posted DESC LIMIT 1;

[ecopetition]

Thanks but a silly question: what's an aggregate?

[obsidian]

Thanks but a silly question: what's an aggregate?

 

An aggregate is any "grouping" of records, such as SUM, AVG, COUNT, etc.