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

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.

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

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.

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

  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.

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?

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.

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:

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

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

the content on the featured panel:

<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

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