show if's
Not sure if this is possible.
Basically I have created a table in a database called 'portfolio' Within that table I have created 4 columns 'PortfolioWebsite', 'PortfolioEmail', 'PortfolioSM' and 'PortfolioSEO'
These columns are either empty (by default) or filled with 1 if the insert or update page check box has been checked for that entry
Now, what I am trying to do is a show if based on the column content rather than whole recordset so that if the column has 1 in it, then the front end will display the icon, if the column is empty then the icon is not shown.
The code, without any show ifs at all) at the moment:
<span id="sprytrigger1"><a href="#"><img alt="Website Design" border="0" height="30" src="/uploads/images/portfolio/website-icon.jpg" width="30" /></a></span>
<span id="sprytrigger2"><a href="#"><img alt="Email Marketing" border="0" height="29" src="/uploads/images/portfolio/email-icon.jpg" width="30" /></a></span>
<span id="sprytrigger3"><a href="#"><img alt="Search Engine Optimisation" border="0" height="30" src="/uploads/images/portfolio/search-icon.jpg" width="27" /></a></span>
<span id="sprytrigger4"><a href="#"><img alt="Social Media" border="0" height="30" src="/uploads/images/portfolio/social-icon.jpg" width="41" /></a></span>
or woould I need to create a recordset for each of these and use the relevant show if for that?
Cheers