This will show a value if it's numeric if not will display the text

<?php
 if (is_numeric ($row_rsclass_events['event_st'] ))
 {
 echo $row_rsclass_events['state_abbrev'] ;
 } else {
 echo $row_rsclass_events['event_st'];
 }
 ?>

This is a good article

http://www.cssstickyfooter.com/using-sticky-footer-code.html

I found though if you set the body height to 100% and also set the content holder css to a of height 100% this will push the footer area down as the content expands downward.

body {
   padding: 0;
   background-color: #FFF;
   background-image: url(headerbg.png);
   background-repeat: repeat-x;
   margin-top: 0;
   height: 100%;
}

 #contentContainer {
   width: 100%;
        height: 100%;
   margin-left: auto;
   margin-right: auto;
   margin-top: 10px;
   clear: both;
}

a normal paypal button would look like this

To only have one payment with a subscription button you will need to remove the "srt" variable. Remove the following statement:

<input type="hidden" name="srt" value="2">

You will need to ensure the "src" variable has a value of 0:

<input type="hidden" name="src" value="0">

 <form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">
                                <p>
                                  <span class="pagetext_11_pt">
                                  <input type="hidden" name="cmd" value="_xclick-subscriptions" />
                                  <input type="hidden" name="bn" value="button" />
                                  <input type="hidden" name="business" value="<?php echo $row_rsfees['rm_paypal_email']; ?>" />
                                  <input type="hidden" name="item_name" value="<?php echo $row_rsclassecho['class_id']; ?> - <?php echo $row_rsclassecho['high_school']; ?> - <?php echo $row_rsclassecho['use_reason']; ?> Reunion Activation 30 Day Free Trial" />
                                  <input type="hidden" name="item_number" value="30 Day Free Trial - <?php echo $row_rsclassecho['class_id']; ?> <?php echo $row_rsclassecho['high_school']; ?>" />
                                  <input type="hidden" name="currency_code" value="USD" />
                                  <input type="hidden" name="a1" value="0" />
                                  <input type="hidden" name="p1" value="1" />
                                  <input type="hidden" name="t1" value="M" />
                                  <input type="hidden" name="a3" value="<?php echo $deferfee ?>" />
                                  <input type="hidden" name="p3" value="1" />
                                  <input type="hidden" name="t3" value="M" />
                                  <input type="hidden" name="image_url" value="/assets/reunionmanagerpaypalfree.png">
                                  <input type="hidden" name="return" value="/paypalconfirm_new.php?class_id=<?php echo $_GET['class_id']; ?>&pay=1" />
                                  <input type="hidden" name="cancel_return" value="/activate_event.php?class_id=<?php echo $_GET['class_id']; ?>" />
                                 <input type="hidden" name="srt" value="2" />
                                  <input type="hidden" name="sra" value="1" />
                                  <input type="hidden" name="receiver_email" value="<?php echo $row_rsfees['rm_paypal_email']; ?>" />
                                  <input type="hidden" name="no_shipping" value="1" />
                                  <input type="hidden" name="no_note" value="1" />
                                  <input type="hidden" name="src" value="0" />
                                  <input type="image" src="assets/orderbuttonfreetrial.png" border="0" name="submit" target="blank" alt="Make payments for Reunion Tickets with PayPal - it's fast, free and secure!" />
                                  </span></p>
                                <p class="pagetext_11_pt"><strong>Please Note: </strong>PayPal will indicate you are making 2 payments, which technically is true.

  Your first payment                                       is for <strong>$0</strong> which covers the <strong>30 Day Free Trial  Period</strong>.

  

                                Cancel anytime before the 30 days is over and the second payment will be canceled.               </p>
                              </form>

The trick is to take out the <input type="hidden" name="srt" value="2" /> entirely. as this can only be set to 2 or above - by taking it out it is for one time based on the reoccurring time frame in the above button this is monthly so by taking it out only 1 more payment would be made at the end of the 30 day trail period.

<?php
// Show IF Conditional
if ($totaloptions != 0) {
?>
                                 <strong>Option Selected</strong>
                                 <?php }
// endif Conditional
?>

Variable in bold

similar to mailto: as an email link use tel: instead

use the urlencode as shown below changing the information to your own

<?php echo (urlencode($row_rshigh_schools_colleges1['sba_group_name'])); ?>'+REUNION'&amp;address=<?php echo (urlencode($row_rshigh_schools_colleges1['sba_group_address'])); ?>

This might not be the prettiest solution and might not actually do everything you need but in a limited way it will display distinct records from a multiple joined record set - this issue is it does not display all the records because it will only show 1 record from a group and not all of them.

$query_rsrandom_lisitngs = "SELECT sba_ad_accounts.sba_cst_ID, sba_ad_accounts.sba_acct_First_Name, sba_ad_accounts.sba_acct_Last_Name, ads_sba.ad_id, ads_sba.ad_company2, ads_sba.ad_city2, ads_sba.ad_zip2, cl_country_sba.iso3, cl_country_regions_sba.country_region_name, ads_sba.alumni_year, sba_ad_categories.ad_cat_tile, sba_ad_sub_categories.ad_sub_cat_tile, sba_alumni_groups.sba_group_name, ads_sba.ad_active, ads_sba.ad_paid FROM ((((((ads_sba LEFT JOIN sba_ad_accounts ON sba_ad_accounts.sba_cst_ID=ads_sba.account_id) LEFT JOIN cl_country_sba ON cl_country_sba.country_id_sba=ads_sba.ad_country2) LEFT JOIN cl_country_regions_sba ON cl_country_regions_sba.country_region_id_sba=ads_sba.ad_country_region_id) LEFT JOIN sba_ad_categories ON sba_ad_categories.ad_cat_id=ads_sba.ad_cat_id_2) LEFT JOIN sba_ad_sub_categories ON sba_ad_sub_categories.ad_sub_cat_id=ads_sba.ad_sup_id_2) LEFT JOIN sba_alumni_groups ON sba_alumni_groups.sba_group_id=ads_sba.ad_alumni_group_id) WHERE ads_sba.ad_active=1  AND ads_sba.ad_paid=1 GROUP BY sba_ad_accounts.sba_cst_ID ORDER BY RAND()";

You need to put the RAND () and the end of the recordset coding as such (at least this worked for us)


SELECT ads_sba.ad_id, ads_sba.account_id, ads_sba.ad_active, ads_sba.ad_company2, ads_sba.ad_city2, cl_states_sba.state_abbrev, ads_sba.ad_zip2, cl_country_regions_sba.country_region_name, cl_country_sba.iso3, sba_alumni_groups.sba_group_name
FROM ((((ads_sba
LEFT JOIN cl_states_sba ON cl_states_sba.state_id_sba=ads_sba.ad_st2)
LEFT JOIN cl_country_sba ON cl_country_sba.country_id_sba=ads_sba.ad_country2)
LEFT JOIN sba_alumni_groups ON sba_alumni_groups.sba_group_id=ads_sba.ad_alumni_group_id)
LEFT JOIN cl_country_regions_sba ON cl_country_regions_sba.country_region_id_sba=ads_sba.ad_country_region_id)
WHERE ads_sba.ad_active=1 ORDER BY RAND()


you can also add the Limit clause like this too ORDER BY RAND() Limit 2,7

Previously we had shown how to make a upload directory for ckfinder dynamic based on a session variable.

http://webglobalnet.net/support/index.php/topic,2497.0.html

This works great the problem becomes how to make this in an admin area correctly go to the right directory when working with multiple accounts and records.

This issue is as far as we can make it work dynamically it must be based on a session variable mainly because we haven't figured out how to pass a URL variable to the config.php file in ckfinder

So what we did when viewing a particular record we created the following when editing the record was on the edit.php page (or what ever you call the edit page):

<?php
$customerid=$row_rsads_sba['account_id'];
$_SESSION['cust_id'] = $customerid;
?>

This creates the correct variable that is needed to go to the right client file upload directory.

In the config.php file in ckfinder we then changed the base url as follows:

$baseUrl = '/admin/ckfinder/userfiles/'.$_SESSION['cust_id'].'/';

and the

$baseDir = '/home/domain/public_html/admin/ckfinder/userfiles/'.$_SESSION['cust_id'].'/';

Change red to your server directory name

and it worked so instead of actually having to login to a clients account we can now work on a clients record in the admin area created.

The .$_SESSION['cust_id'] variable is overwritten for each separate client record you may be looking at each time

This seems to work to wrap text using a table adjust CSS width to fit space needed

<table  border="0" cellpadding="0" cellspacing="0" id="box_word_wrap">
  <tr>
    <td><div class="pagetext_11_pt"><?php echo $row_rsrecordset['donation_description']; ?></div> </td>
  </tr>
</table>

CSS
#box_word_wrap
 {
   width: 250px;
   height: 15px;
   margin: 0px;
   padding: 0px;
   white-space: pre-wrap;       /* css-3 */
    white-space: -moz-pre-wrap;  /* Mozilla, since 1999 */
    white-space: -pre-wrap;      /* Opera 4-6 */
    white-space: -o-pre-wrap;    /* Opera 7 */
    word-wrap: break-word;       /* Internet Explorer 5.5+ */
}