From 2080897f3b87ac1c1653232491c8bba56ede60f7 Mon Sep 17 00:00:00 2001 From: plegall Date: Tue, 1 Dec 2015 13:53:57 +0100 Subject: faster SQL, by @mistic100 --- include/ws_functions/pwg.categories.php | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'include') diff --git a/include/ws_functions/pwg.categories.php b/include/ws_functions/pwg.categories.php index 4fece14ec..07e64c803 100644 --- a/include/ws_functions/pwg.categories.php +++ b/include/ws_functions/pwg.categories.php @@ -676,12 +676,12 @@ function ws_categories_deleteRepresentative($params, &$service) // does the category really exist? $query = ' -SELECT COUNT(*) +SELECT id FROM '. CATEGORIES_TABLE .' WHERE id = '. $params['category_id'] .' ;'; - list($count) = pwg_db_fetch_row(pwg_query($query)); - if ($count == 0) + $result = pwg_query($query); + if (pwg_db_num_rows($result) == 0) { return new PwgError(404, 'category_id not found'); } @@ -713,12 +713,12 @@ function ws_categories_refreshRepresentative($params, &$service) // does the category really exist? $query = ' -SELECT COUNT(*) +SELECT id FROM '. CATEGORIES_TABLE .' WHERE id = '. $params['category_id'] .' ;'; - list($count) = pwg_db_fetch_row(pwg_query($query)); - if ($count == 0) + $result = pwg_query($query); + if (pwg_db_num_rows($result) == 0) { return new PwgError(404, 'category_id not found'); } -- cgit v1.2.3