X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fsales_groups_db.inc;h=61fbcdc5182b1e6bd754dcb73c3f4833c7792148;hp=6f926d7ee7887d1e3f5eaa091a8d796be8470646;hb=c9cb6e8b05e007305888f244807abda14632205e;hpb=b14f304532b7d124e79ee2a03d60a0850c8a417d

diff --git a/sales/includes/db/sales_groups_db.inc b/sales/includes/db/sales_groups_db.inc
index 6f926d7e..61fbcdc5 100644
--- a/sales/includes/db/sales_groups_db.inc
+++ b/sales/includes/db/sales_groups_db.inc
@@ -12,25 +12,25 @@
 
 function add_sales_group($description)
 {
-	$sql = "INSERT INTO ".TB_PREF."groups (description) VALUES (".db_escape($description) . ")";
+	$sql = "INSERT INTO `".TB_PREF."groups` (description) VALUES (".db_escape($description) . ")";
    	db_query($sql,"The sales group could not be added");
 }
 
 function update_sales_group($selected_id, $description)
 {
-	$sql = "UPDATE ".TB_PREF."groups SET description=".db_escape($description)." WHERE id = ".db_escape($selected_id);
+	$sql = "UPDATE `".TB_PREF."groups` SET description=".db_escape($description)." WHERE id = ".db_escape($selected_id);
    	db_query($sql,"The sales group could not be updated");
 }
 
 function delete_sales_group($selected_id)
 {
-	$sql="DELETE FROM ".TB_PREF."groups WHERE id=".db_escape($selected_id);
+	$sql="DELETE FROM `".TB_PREF."groups` WHERE id=".db_escape($selected_id);
 	db_query($sql,"could not delete sales group");
 }
 
 function get_sales_groups($show_inactive)
 {
-	$sql = "SELECT * FROM ".TB_PREF."groups";
+	$sql = "SELECT * FROM `".TB_PREF."groups`";
 	if (!$show_inactive) $sql .= " WHERE !inactive";
 	$sql .= " ORDER BY description";
 	return db_query($sql,"could not get groups");
@@ -38,7 +38,7 @@ function get_sales_groups($show_inactive)
 
 function get_sales_group($selected_id)
 {
-	$sql = "SELECT * FROM ".TB_PREF."groups WHERE id=".db_escape($selected_id);
+	$sql = "SELECT * FROM `".TB_PREF."groups` WHERE id=".db_escape($selected_id);
 
 	$result = db_query($sql,"could not get group");
 	return db_fetch($result);
@@ -46,7 +46,7 @@ function get_sales_group($selected_id)
 
 function get_sales_group_name($group_no)
 {
-	$sql = "SELECT description FROM ".TB_PREF."groups WHERE id = ".db_escape($group_no);
+	$sql = "SELECT description FROM `".TB_PREF."groups` WHERE id = ".db_escape($group_no);
 	$result = db_query($sql, "could not get group");
 	$row = db_fetch($result);
 	return is_array($row) ? $row[0] : false;