if someone could help i would appreciate, what i have done now is generated a recordset which shows all the products not sold in a table:
so it reads for example:
When the insurance is 0 it means they have not been sold which is great it displays. What i want to do then in my table is instead of:
<?php echo $row_rsNotGotGIorProtection['generalInsurance']; ?>
have it show a a RED Cross image i have. so if it is 0 it displays the red cross and if it is 1 then that means it has been sold and i would like it to display the GREEN Tick image i have.
I am sure this could be done using Show Regions but if someone could guide me through it and how to display if 0=red cross and 1=green tick.
Also on the page I have a drop down list with a filter button.
I have then 4 other recordsets on the page which are for the individual product.
So again like the above but this time not every product the individual products so if 0=not sold.
I want to click on the product from the drop down list, say "product1" then click the filter button.
It will then trigger the recordset associated with that product and display that table on the page and not the anything else.
Again if someone could help me through this part as i know roughly the steps now and have got this far i just need step by step on these steps to implement to finish this off.
Many thanks for your help