close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How can I show a link when a recordset value is present and hide it when not?

Thread began 5/28/2015 11:50 am by Cameron | Last modified 5/28/2015 3:27 pm by Ray Borduin | 321 views | 2 replies |

Cameron

How can I show a link when a recordset value is present and hide it when not?

I'm working on an ecommerce store that sells clothing in MySQLi. I'm trying to have a link showing on my product page that goes to a detail page for an optional accessory that only shows when the option is present in my recordset for that particular product. I don't want it to show when the option is not present. My recordset "rsExtras" populates a dropdown with matching shorts, etc. for some products. When the value is present (I'm using OptionID from within rsExtras), I'd like to have a link to a detail page appear. I tried to modify the MySQLi "Show If" that is generated but I've no idea about the syntax, so it's been a shot in the dark that's borne no fruit so far. I know that there's a difference between the show if for an empty vs present recordset and an empty vs present specific value. Any suggestions?

Sign in to reply to this post

Ray BorduinWebAssist

php:
<?php

if ($rsExtras->getColumnVal("OptionID")) {
?>
Show this if there is a value
<?php
}
?>
Sign in to reply to this post

Cameron

Many thanks Ray! Thanks for getting back to me so quickly!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...