From 8ec7a2500fb3a257cd5ea7cb0ebd0ef560beaa63 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 3 Aug 2011 13:11:04 +0200 Subject: [PATCH] Fixed key_in_foreign_table helper (problems with non-numeric keys). --- admin/db/company_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/db/company_db.inc b/admin/db/company_db.inc index c1197dc..5ef6798 100644 --- a/admin/db/company_db.inc +++ b/admin/db/company_db.inc @@ -191,7 +191,7 @@ function key_in_foreign_table($id, $tables, $stdkey, $escaped=false) $tbl = $key; $key = $stdkey; } - $sqls[] = "(SELECT COUNT(*) as cnt FROM ".TB_PREF."$tbl WHERE $key=$id)\n"; + $sqls[] = "(SELECT COUNT(*) as cnt FROM `".TB_PREF."$tbl` WHERE `$key`=".db_escape($id).")\n"; } $sql = "SELECT sum(cnt) FROM (". implode(' UNION ', $sqls).") as counts"; -- 2.30.2