From 6b0e05889607942fc99e3cf4accf0ec40d702552 Mon Sep 17 00:00:00 2001 From: Chanaka Indrajith Date: Thu, 1 Nov 2012 23:19:29 +0530 Subject: Generate correct SQL when export set of resulted rows --- tbl_export.php | 36 ++++++++++++------------------------ 1 file changed, 12 insertions(+), 24 deletions(-) (limited to 'tbl_export.php') diff --git a/tbl_export.php b/tbl_export.php index 6dfd6960ea..2158b7e869 100644 --- a/tbl_export.php +++ b/tbl_export.php @@ -35,33 +35,21 @@ if (! empty($sql_query)) { // Need to generate WHERE clause? if (isset($where_clause)) { - // Yes => rebuild query from scratch; this doesn't work with nested - // selects :-( - $sql_query = 'SELECT '; - if (isset($analyzed_sql[0]['queryflags']['distinct'])) { - $sql_query .= ' DISTINCT '; - } - - $sql_query .= $analyzed_sql[0]['select_expr_clause']; - - if (!empty($analyzed_sql[0]['from_clause'])) { - $sql_query .= ' FROM ' . $analyzed_sql[0]['from_clause']; - } + $temp_sql_array = explode("where", strtolower($sql_query)); - $wheres = array(); - - if (isset($where_clause) && is_array($where_clause) - && count($where_clause) > 0) { - $wheres[] = '(' . implode(') OR (', $where_clause) . ')'; - } - - if (!empty($analyzed_sql[0]['where_clause'])) { - $wheres[] = $analyzed_sql[0]['where_clause']; - } + // The fields which is going to select will remain + // as it is regardless of the where clause(s). + // EX :- The part "SELECT `id`, `name` FROM `customers`" + // will remain same when representing the resulted rows + // from the following query, + // "SELECT `id`, `name` FROM `customers` WHERE id NOT IN + // ( SELECT id FROM companies WHERE name LIKE '%u%')" + $sql_query = $temp_sql_array[0]; - if (count($wheres) > 0) { - $sql_query .= ' WHERE (' . implode(') AND (', $wheres) . ')'; + // Append the where clause using the primary key of each row + if (is_array($where_clause) && (count($where_clause) > 0)) { + $sql_query .= ' WHERE (' . implode(') OR (', $where_clause) . ')'; } if (!empty($analyzed_sql[0]['group_by_clause'])) { -- cgit v1.2.3