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

featured member

Thread began 1/23/2013 6:17 am by JamieEff | Last modified 1/25/2013 7:56 am by JamieEff | 1005 views | 22 replies |

JamieEff

featured member

Hey Jason

Am trying to create a 'featured member' for a home page which is able to be selected by the client manually by entering a number which correlates to a member.

The table is set up with MemberID but I dont know how to set the filter (and adjust the code) to allow for this......

<h2> Featured Member</h2>
<?php echo $row_FeaturedMember['CompanyName']; ?>
<?php echo $row_FeaturedMember['CompanyBio']; ?>
</div>

I have attached screenshot of the recordset

I plan on just creating a PCMS content area which will allow the user to enter a number to change the featured company and bio to change etc

Thanks

Jamie

Sign in to reply to this post

Jason ByrnesWebAssist

what column in the table marks the member as being featured?

In the filtering section, selected the featured column, for the filter type, select entered value, then enter the value that marks that member as being featured.

Sign in to reply to this post

JamieEff

there isnt a featured column as such... I was just going to use the MemberID column to allow the client to enter 2, 3, 8 or whatever in a PCMS content field

That number would then be used as part of the code in the featured member area to display the company name and alsoa brief bio for the member that is assocaiated with the number that has been entered above....

(sorry if am not being terribly clear, but am not sure of the right terminology to express what I am trying to do and how...)

Sign in to reply to this post

Jason ByrnesWebAssist

doing it that way wont work.

you would need a column to mark the user as featured. you can use Data Assist to create a user manager set of pages so that the client can select the featured member.

when they select the featured member, it will set the featured column to 1.

Sign in to reply to this post

JamieEff

ok... and, you probably guessed the next bit.... how do I do that? lol

Sign in to reply to this post

Jason ByrnesWebAssist

  how do I do that? lol  



already answered.

  you can use Data Assist to create a user manager set of pages so that the client can select the featured member.  



Add the Featured column to the members table.

run the data assist wizard to create pages for managing the members table.

Sign in to reply to this post

JamieEff

I already have a table for the member info and _results, _update and _insert pages for the members....

do I just add a 'FeaturedMember' column to that table and then add a check box or something for that column to the data bridge pages above?

or do I need a completely new column and set of pages?

Sign in to reply to this post

Jason ByrnesWebAssist

add the featured column to the table, set the default value to 0

add the checkbox to the insert and update pages

on the insert page set the checked value to 1

on the update page, update the recordset to include the featured column. use the dynamic button in the properties inspector for the checkbox, set the Check if option to the featured column from the recordset, and set the value to 1.

then update the insert and update behaviors and bind the featured column to the checkbox.

Sign in to reply to this post

JamieEff

Thanks... not sure what am i am doing wrong with your steps....

have added the featuredmember column to the table, have added

heres the update page checkbox:

html:
<label for="FeaturedMember" class="sublabel" > Featured Member? <input <?php if (!(strcmp($row_WADAmember_info['FeaturedMember'],1))) {echo "checked=\"checked\"";} ?> name="checkbox" type="checkbox" id="checkbox" value="1" /></label>



heres the insert page checkbox:

html:
<label for="FeaturedMember" class="sublabel" > Featured Member? <input name="checkbox" type="checkbox" id="checkbox" value="1" /></label>



the content on the featured panel:

html:
<h2> Featured Member</h2>
<?php echo $row_FeaturedMember['CompanyName']; ?>
<?php echo $row_FeaturedMember['CompanyBio']; ?>



and the recordset for the page with the featured member content on it is:

SELECT CompanyName, CompanyBio, FeaturedMember
FROM member_info
ORDER BY FeaturedMember ASC

Sign in to reply to this post

Jason ByrnesWebAssist

you have to update the featured recordset to filter the featured user column on the entered value 1.

Sign in to reply to this post
loading

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...