215 Posts
8 years ago
0
Topic
I'm trying this code because I'd like to run a different MySQL searches in the Search Query Field depending on the form.
IF ($uri->getValue('x_wci_sku') IS NOT NULL) THEN
SELECT a.wci_sku, b.fti_sku, b.description, a.qty_onhand
FROM #__cck_free_form_xref_qty AS a
JOIN #__cck_free_form_xref AS b
ON a.wci_sku = b.wci_sku
WHERE [MATCH]b.wci_sku||$uri->getValue('x_wci_sku')[/MATCH]
END IF
but alas it's not working... is this possible? Trying to run different MySQL select commands based on the HTML form
