215 Posts
cubist
6 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

Get a Book for SEBLOD