Hi,
I have a question regarding a mysql query which I don't completly understand. The query is:
$requete= "SELECT id,libelle,site_h,date FROM articles WHERE date > ".date("Y-m-d", (time()-3600))." ORDER BY date LIMIT 20";
Will this query return
-the 20 most recent rows from the articles table(with date > time()-3600)?
-20 rows (with date > time()-3600) from the articles table, but not necessarily the most recent ones?
Thanks in advance,
Emilien Arino
I have a question regarding a mysql query which I don't completly understand. The query is:
$requete= "SELECT id,libelle,site_h,date FROM articles WHERE date > ".date("Y-m-d", (time()-3600))." ORDER BY date LIMIT 20";
Will this query return
-the 20 most recent rows from the articles table(with date > time()-3600)?
-20 rows (with date > time()-3600) from the articles table, but not necessarily the most recent ones?
Thanks in advance,
Emilien Arino