Fetching latest entry from MySQL Database

[pacchiee]

Hello,

 

I have a table with three columns - id, product, date. id is unique + auto increment. Entries of many products go into the same table along with date.

 

Now, I need to fetch the latest entry from this table for a given product based on date, which am not able to do.

 

Please help. Thanks in Advance.

[rhodesa]

first...i would highly recommend not using 'date' as a column name since it is a reserved word in MySQL.

 

but, the query should be:

SELECT * FROM tableName WHERE product = 'foobar' ORDER BY `date` DESC LIMIT 1

[PFMaBiSmAd]

And what format is your date?

[pacchiee]

first...i would highly recommend not using 'date' as a column name since it is a reserved word in MySQL.

 

Oh! Okay, I will change it.

 

And what format is your date?

 

It is in YYYY-MM-DD format.

[pacchiee]

Further, how to select data from this table by matching only date or month or year?

 

For instance, lets assume $today = date('Y-m-d');

 

SELECT * FROM tableName WHERE product = 'foobar' AND MONTH(date) = MONTH($today)

 

Is that correct?

[fenway]

Looks fine to me