summaryrefslogtreecommitdiffstats
path: root/editcomponents.cgi
diff options
context:
space:
mode:
Diffstat (limited to 'editcomponents.cgi')
-rwxr-xr-xeditcomponents.cgi7
1 files changed, 4 insertions, 3 deletions
diff --git a/editcomponents.cgi b/editcomponents.cgi
index a86329d9d..9dd290db3 100755
--- a/editcomponents.cgi
+++ b/editcomponents.cgi
@@ -81,9 +81,10 @@ sub TestComponent ($$)
# does the product/component combination exist?
SendSQL("SELECT components.name
- FROM components, products
- WHERE products.id = components.product_id
- AND products.name = " . SqlQuote($prod) . "
+ FROM components
+ INNER JOIN products
+ ON products.id = components.product_id
+ WHERE products.name = " . SqlQuote($prod) . "
AND components.name = " . SqlQuote($comp));
return FetchOneColumn();
}