I have a table that i would like to perform a query and return the data to a form depending on the form select value.
I have tried the following:
SELECT productserial
FROM productinfo
WHERE custid = colname
ORDER BY productserial ASC
and
SELECT productserial
FROM productinfo
WHERE productname LIKE '%shocker%' //value of '%?%' depends on text in select box
ORDER BY productserial ASC
pretty much what i would like to do is if form is passed with $custid = 100 a dropdown box is created with rows = to productid and owned by custid 100. ( this is already done. )
then
if product 1 is chosen from select ( which will be default ) then productserial relating to custid 100's product is displayed, or if product2 is selected from dropdown then productserial for custid 100's product is displayed.
i hope this makes sense.
V
