diff options
| author | plegall <plg@piwigo.org> | 2006-02-23 21:38:00 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2006-02-23 21:38:00 +0000 |
| commit | 5865079907e0f2bfa2ee3e5b840929fefe361fc5 (patch) | |
| tree | aa8d807d02ea1a9dd04c479d3d4af6453fbe714e /include/functions_category.inc.php | |
| parent | 01b388d518d664eea52ce8678d5da3df7e44f2ab (diff) | |
bug 278 fixed: calendar on date_available could not work because
date_available has a datetime MySQL column format while date_creation has a
date MySQL column format. We use DATE_FORMAT MySQL function to resolv this
issue.
git-svn-id: http://piwigo.org/svn/branches/branch-1_5@1054 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | include/functions_category.inc.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php index ad118a905..fc2bb3c25 100644 --- a/include/functions_category.inc.php +++ b/include/functions_category.inc.php @@ -487,7 +487,7 @@ function initialize_category( $calling_page = 'category' ) $key = $datefield; if (isset($search['fields'][$key])) { - $local_clause = $datefield." = '"; + $local_clause = 'DATE_FORMAT('.$datefield.", '%Y-%m-%d') = '"; $local_clause.= str_replace('.', '-', $search['fields'][$key]['words'][0]); $local_clause.= "'"; |