From 13ea9d50e35d9dd8cf7235a39d97a344e6091ea0 Mon Sep 17 00:00:00 2001 From: nikrou Date: Wed, 25 Nov 2009 19:02:57 +0000 Subject: Feature 1255: modification in sql queries - manage random function - manage regex syntax - manage quote (single instead of double) - manage interval git-svn-id: http://piwigo.org/svn/trunk@4367 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/element_set.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'admin/element_set.php') diff --git a/admin/element_set.php b/admin/element_set.php index 1c84854d5..ce9ce63da 100644 --- a/admin/element_set.php +++ b/admin/element_set.php @@ -196,7 +196,7 @@ elseif ('recent'== $_GET['cat']) { $query = 'SELECT id FROM '.IMAGES_TABLE.' - WHERE date_available BETWEEN DATE_SUB("'.$row['date'].'", INTERVAL 1 DAY) AND "'.$row['date'].'"'; + WHERE date_available BETWEEN '.pwg_db_get_recent_period_expression(1, $row['date']).' AND \''.$row['date'].'\''; $page['cat_elements_id'] = array_from_query($query, 'id'); } } -- cgit v1.2.3