I figured this out, I won't bore you with the details. :)

Thanks much!

Well, the mobile site is a bit weird at the moment, I do use it, but the main catalog on the mobile site is not on the sub-domain, it's yogamerge.com/mobile.php

However, the home page is m.yogamerge.com and the class pages are m.yogamerge.com/mobile-pages/classpages/nikkanadia/

I set it up this way after installing cms, because I knew that I could make cms work in that manner on the mobile site, as I was also unsure then about using cms on a sub domain.

I had one other quick question on this topic.

I would also like to filter records on my mobile site just as we have done on the desktop page that we worked on in this topic.

I think though the issue is that my yoga class mobile pages are on a sub-domain like this:

m.yogamerge.com/mobile-pages/classpages/nikkanadia/restorative-flow-test.php

My include file is here:

yogamerge.com/includes/mobile-instructor-records.php

So what would the below code need to look like on restorative-flow-test.php in order to display and filter the records using the above located include?

<?php
  $category = "Nikka-Nadia"; // name of category to load
  include('../../includes/mobile-instructor-records.php');
?>

Or is it not possible to do this if the mobile page is within a sub-domain?

Is it possible to display records from cms on a sub-domain (m.yogamerge.com) of your main domain (yogamerge.com)?

Thanks as always,

Kent

Just submitted the support request with requested details.

Kent

Yeah, I thought of that last night and tried it, but it still didn't load any records.

Looks like I have stumbled across a frustrating issue, lol

Sorry for all the trouble, what do you suggest next?

Sure, I attached a screen shot of that area of the admin.

Thanks much.

Kent

Well, I'm still not getting any records to load on the page and there's no error.

Sorry for all the trouble.

My current code is below -

On the page:

<?php
  $category = "nikka-nadia"; // name of category to load
  include("includes/nikka-nadia-classes.php");
?>

On the include:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/web/sites/greywood/yogamerge.com/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  // load records from 'all_classes'
list($all_classesRecords, $all_classesMetaData) = getRecords(array(
 'tableName'   => 'all_classes',
 'perPage'     => '10',
 'loadUploads' => true,
 'allowSearch' => false,
 'where'       => "`categories` LIKE '\t". mysql_escape($category) ."\t'",
));

?>

also on the include:

<?php foreach ($all_classesRecords as $record): ?>

I wanted to mention that I uses includes on a variety of pages for navigation menus, etc. and I have always had to use a full url path to the include file if the page was buried within a variety of folders, yogamerge.com/classpages/nikkanadia/restorative-flow-test.php

However, that didn't help in this instance.

The category field is a multi select check box, records can have and in all cases do have multiple categories.

Thanks!

I made your change which makes sense to me, but unfortunately I still get no records displayed. I no longer have the error saying no records found, but there's no records displayed on the page, you can see it using the below link:

http://www.yogamerge.com/classpages/nikkanadia/restorative-flow-test.php

So far it only works when I take it back to displaying all records with no attempt to filter the records with a category.

Thanks for all the help!

Kent

Thanks for the response!

I do have that line in the code on restorative-flow-test.php

I have actually tried it two different ways shown below:

Right now it's set as this:

<?php $category = "nikka-nadia"; // name of category to load ?>
       <?php include("http://www.yogamerge.com/includes/nikka-nadia-classes.php");?>

 Before it was set as this:

<?php $category = "nikka-nadia"; // name of category to load 
      include("http://www.yogamerge.com/includes/nikka-nadia-classes.php");?>

I wasn't sure if the category variable should be in the same php statement as the include?

I get the error either way. I attached my current restorative-flow-test.php page to this reply.

I now get the following error after making the changes.

Notice: Undefined variable: category in /web/sites/greywood/yogamerge.com/includes/nikka-nadia-classes.php on line 17 No records were found!

Thanks much,

Kent

Update:

I changed the code in the where statement, it looked like there might be a typo with this:

'where'       => "categories = '". mysql_escape($category) ."",

I changed it to:

'where'       => "categories = "". mysql_escape($category) ."", 

I no longer get the error, however I get no classes at all displayed via the include statement on restorative-flow-test.php

Thanks much.

Thanks for the help!

I seem to still get an error after using your code, not positive I applied it correctly but I think I did. I get the below error -

Notice: Undefined variable: category in /web/sites/greywood/yogamerge.com/includes/nikka-nadia-classes.php on line 17 MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '') ORDER BY dragSortOrder DESC LIMIT 10' at line 3

The include file is now called nikka-nadia-classes.php and is below

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/web/sites/greywood/yogamerge.com/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  // load records from 'all_classes'
  list($all_classesRecords, $all_classesMetaData) = getRecords(array(
    'tableName'   => 'all_classes',
    'perPage'     => '10',
    'loadUploads' => true,
    'allowSearch' => true,
    'where'       => "categories = '". mysql_escape($category) ."",
  ));

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style>
</style>


<TITLE></TITLE>
 

<script language="JavaScript">
<!--//BEGIN Script
function new_window(url) {

link = window.open(url,"Link","toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0,resizable=0,width=750,height=675,left=80,top=180");

}
//END Script-->
</script>


</head>



<body font face="Verdana, Arial, Helvetica, sans-serif" size="2" text="#000000" link="#000000">

  

<?php foreach ($all_classesRecords as $record): ?>
               
    
<table width="950" table  cellspacing="5" valign="TOP" nowrap>

<tr align="CENTER" bgcolor="#000000" link="#FFFFFF" vlink="#FFFFFF">

<Td><font color="white" font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Class</b></Td><td width="950" colspan="3"><b><font color="white" font face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo htmlencode($record['title']) ?></b></td></a>

<TD><font color="white" font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b><?php echo htmlencode($record['download_price']) ?></b></TD></tr>

<tr>

<td rowspan="4" align="CENTER" valign="TOP">

<a href="<?php echo htmlencode($record['preview_link']) ?>"><?php echo $record['thumb']; ?><font face="Verdana, Arial, Helvetica, sans-serif" font size="2" font color="000000" link="#FFFFFF" vlink="#FFFFFF"><B>PREVIEW</B></a><P>
</TD>





</TD></tr>

<tr>

<td  nowrap><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Style: </b><?php echo htmlencode($record['style']) ?></td>

<td  nowrap>

</td>

<td nowrap><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Length: </b><?php echo htmlencode($record['class_length']) ?></td>

<td nowrap> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Media: </b><?php echo htmlencode($record['media']) ?></TD>

</tr>

</TR>

<tr>

<td colspan="3" class="desc" width="400"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Instructor: </b><?php echo htmlencode($record['instructor']) ?></TD>
<TD noWrap><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>HD: </b><?php echo htmlencode($record['format']) ?></TD></TR>

<tr><td width="1100" colspan="3" class="desc"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Level: </b><?php echo htmlencode($record['class_level']) ?> 
                                     <?php echo htmlencode($record['description']) ?><P>

                                      
</td>

<td align="center">

<?php echo $record['add_to_cart']; ?><P>






</tr>

</table>


      
    <?php endforeach ?>

    <?php if (!$all_classesRecords): ?>
      No records were found!<br/><br/>
    <?php endif ?>

<br>
<br>




 
 
</body>
</html>

 The main page where the include is used is still restorative-flow-test.php and is below -

<html>
<head>
<link rel="stylesheet" type="text/css" href="http://www.yogamerge.com/bodystyle-new.css">
<style>
h1
{
color:336699;
font-family:Verdana, Arial, Helvetica, sans-serif;
text-align:center;
font-size:18px;
}
#cssmenu ul,
#cssmenu li,
#cssmenu span,
#cssmenu a {
  margin: 0;
  padding: 0;
  position: relative;
}
#cssmenu:after,
#cssmenu ul:after {
  content: '';
  display: block;
  clear: both;
}
#cssmenu a {
  color: #ffffff;
  display: inline-block;
  font-family: "Lucida Grande", "Lucida Sans Unicode", Helvetica, Arial, Verdana, sans-serif;
  font-size: 13.4px;
  min-width: 35px;
  text-align: center;
  text-decoration: none;
  text-shadow: 0 -1px 0 #333333;
}
#cssmenu ul {
  list-style: none;
}
#cssmenu > ul > li {
  float: left;
}
#cssmenu > ul > li.active a {
  background: #646464 url(images/grad_dark.png) repeat-x left bottom;
  background: -moz-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, #646464), color-stop(100%, #4a4a4a));
  background: -webkit-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: -o-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: -ms-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: linear-gradient(to bottom, #646464 0%, #4a4a4a 100%);
  filter: progid:dximagetransform.microsoft.gradient(startColorstr='#646464', endColorstr='#4a4a4a', GradientType=0);
  box-shadow: inset 0 0 10px #222222, inset 0 10px 10px #222222;
  -moz-box-shadow: inset 0 0 10px #222222, inset 0 10px 10px #222222;
  -webkit-box-shadow: inset 0 0 10px #222222, inset 0 10px 10px #222222;
  filter: none;
}
#cssmenu > ul > li.active a:hover {
  background: -moz-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, #646464), color-stop(100%, #4a4a4a));
  background: -webkit-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: -o-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: -ms-linear-gradient(top, #646464 0%, #4a4a4a 100%);
  background: linear-gradient(to bottom, #646464 0%, #4a4a4a 100%);
  filter: progid:dximagetransform.microsoft.gradient(startColorstr='#646464', endColorstr='#4a4a4a', GradientType=0);
  filter: none;
}
#cssmenu > ul > li a {
  box-shadow: inset 0 0 0 1px #8a8a8a;
  -moz-box-shadow: inset 0 0 0 1px #8a8a8a;
  -webkit-box-shadow: inset 0 0 0 1px #8a8a8a;
  background: #4a4a4a url(images/grad_dark.png) repeat-x left top;
  background: -moz-linear-gradient(top, #8a8a8a 0%, #707070 50%, #626262 51%, #787878 100%);
  background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, #8a8a8a), color-stop(50%, #707070), color-stop(51%, #626262), color-stop(100%, #787878));
  background: -webkit-linear-gradient(top, #8a8a8a 0%, #707070 50%, #626262 51%, #787878 100%);
  background: -o-linear-gradient(top, #8a8a8a 0%, #707070 50%, #626262 51%, #787878 100%);
  background: -ms-linear-gradient(top, #8a8a8a 0%, #707070 50%, #626262 51%, #787878 100%);
  background: linear-gradient(to bottom, #8a8a8a 0%, #707070 50%, #626262 51%, #787878 100%);
  filter: progid:dximagetransform.microsoft.gradient(startColorstr='#8a8a8a', endColorstr='#787878', GradientType=0);
  border-bottom: 1px solid #5d5d5d;
  border-top: 1px solid #5d5d5d;
  border-right: 1px solid #5d5d5d;
  line-height: 34px;
  padding: 0 35px;
  filter: none;
}
#cssmenu > ul > li a:hover {
  background: #8a8a8a url(images/grad_dark.png) repeat-x left bottom;
  background: -moz-linear-gradient(top, #646464 0%, #4a4a4a 50%, #3b3b3b 51%, #525252 100%);
  background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, #646464), color-stop(50%, #4a4a4a), color-stop(51%, #3b3b3b), color-stop(100%, #525252));
  background: -webkit-linear-gradient(top, #646464 0%, #4a4a4a 50%, #3b3b3b 51%, #525252 100%);
  background: -o-linear-gradient(top, #646464 0%, #4a4a4a 50%, #3b3b3b 51%, #525252 100%);
  background: -ms-linear-gradient(top, #646464 0%, #4a4a4a 50%, #3b3b3b 51%, #525252 100%);
  background: linear-gradient(to bottom, #646464 0%, #4a4a4a 50%, #3b3b3b 51%, #525252 100%);
  filter: progid:dximagetransform.microsoft.gradient(startColorstr='#8a8a8a', endColorstr='#787878', GradientType=0);
  filter: none;
}
#cssmenu > ul > li:first-child a {
  border-radius: 5px 0 0 5px;
  -moz-border-radius: 5px 0 0 5px;
  -webkit-border-radius: 5px 0 0 5px;
  border-left: 1px solid #5d5d5d;
}
#cssmenu > ul > li:last-child a {
  border-radius: 0 5px 5px 0;
  -moz-border-radius: 0 5px 5px 0;
  -webkit-border-radius: 0 5px 5px 0;
}
#cssmenu .has-sub:hover ul {
  display: block;
}
#cssmenu .has-sub ul {
  display: none;
  position: absolute;
  top: 36px;
  left: -1px;
  min-width: 100%;
  text-align: center;
  /* IE7 */

  *width: 100%;
}
#cssmenu .has-sub ul li {
  text-align: center;
}
#cssmenu .has-sub ul li a {
  border-top: 0 none;
  border-left: 1px solid #5d5d5d;
  display: block;
  line-height: 120%;
  padding: 9px 5px;
  text-align: center;
}
</style>

<TITLE>Streaming Yoga - Online Yoga Video With A Mix Of Restorative & Flow</TITLE>

<META  NAME="Description" CONTENT="Beginner yoga video with a mix of restorative postures and flow movement.">

<META  NAME="Keywords" CONTENT="yoga videos, yoga video, online yoga classes, yoga studio, instruction, streaming yoga, meditation, video poses demonstration, yoga pose, 
yoga styles, experienced yoga teachers, health, community, workshops, downloads, vinyasa flow, anusara, ashtanga, kundalini, iyengar, prenatal, tantra, los angeles, california, 
Upanishads, bhagavad gita, yoga sutras, beginner, intermediate, advanced, pranayama, ayurveda, hatha, therapy, philosophy, wellness, yogi, asana, lessons, stress reduction,
workout, core work, inversions, head stands, hand stands, arm balances">

<meta content='700240980117234' property='fb:app_id'>

<meta property="og:title" content="Streaming Yoga" />
<meta property="og:type" content="article" />
<meta property="og:image" content="http://www.yogamerge.com/video-thumbs/img_nikka-restorative-flow-preview-thumb.jpg" />
<meta property="og:url" content="http://www.yogamerge.com/classpages/nikkanadia/restorative-flow.php" />
<meta property="og:description" content="Online Yoga Video With A Mix Of Restorative & Flow" />

<meta name="twitter:card" content="summary_large_image" />
<meta name="twitter:site" content="@yogamerge">
<meta name="twitter:title" content="Streaming Yoga" />
<meta name="twitter:description" content="Online Yoga Video With A Mix Of Restorative & Flow" />
<meta name="twitter:image" content="http://www.yogamerge.com/video-thumbs/img_nikka-restorative-flow-preview-thumb.jpg" />

<link rel="image_src" href="http://www.yogamerge.com/video-thumbs/img_nikka-restorative-flow-preview-thumb.jpg"/>

<link rel="alternate" media="only screen and (max-width: 800px)"
      href="http://m.yogamerge.com/mobile-pages/classpages/nikkanadia/restorative-flow.php" >

<script type="text/javascript">
<!--
if (screen.width <= 800) {
document.location = "http://m.yogamerge.com/mobile-pages/classpages/nikkanadia/restorative-flow.php";
}
//-->
</script>


<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-44365450-1', 'yogamerge.com');
  ga('send', 'pageview');

</script>

<div id="fb-root"></div>
<script>(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.0";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>



<script language="JavaScript">
<!--//BEGIN Script
function new_window(url) {

link = window.open(url,"Link","toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0,resizable=0,width=750,height=675,left=80,top=180");

}
//END Script-->
</script>

<link href="/vibracart/vibracartstyle1.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="/vibracart/settingsstyle1.js"></script>
<script type="text/javascript" src="/vibracart/sarissa.js"></script>
<script type="text/javascript" src="/vibracart/vibracart.js"></script>

</head>
<text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF">

<!--DO NOT REMOVE THIS TEXT! Template provided by http://www.2file:///Mac%20HardDrive/WebSites/newpagetest2.htmlcreateawebsite.com.  For more free templates go to http://www.2createawebsite.com/build/templates.html-->

  <body>
  <body bgcolor="#FFFFFF" body link="#000000" vlink="#000000" alink="#000000">
    <tr>
      <td width="50%">
        <div align="center">
          <table border="1" width="50%" bgcolor="#FFFFFF" link="#FFFFFF" cellspacing="1" cellpadding="4">
            <tr>        
            <td width="50%" valign="top">
                
                
                <div align="center">
                  <center>

              <table width="800" border="0" cellspacing="0" cellpadding="3" align="center" bgcolor="#FFFFFF">
  <tr valign="top"> 
    <td> 
      <div align="center"> 
        
<?php include("http://www.yogamerge.com/includes/class-instructor-header.html");?>


<table width="950" table  cellspacing="5" valign="TOP" nowrap>

<tr align="CENTER" bgcolor="#000000" link="#FFFFFF">

<Td><font color="white" font face="Verdana, Arial, Helvetica, sans-serif"><b>Nikka's Laid Back Restorative Flow</b></Td></tr>

<tr>

<td rowspan="4" align="CENTER" valign="TOP">

<video id="restorative-flow" width="950" height="534" poster="http://www.yogamerge.com/video-thumbs/img_nikka-restorative-flow-preview-thumb.jpg" preload controls>
<source src="http://d1h6n356rif2ap.cloudfront.net/nikka-restorative-flow-preview.mp4" />
</video></TD>





</TD></tr>

</table>

<table width="950">
<tr>
<td>
<!---Insert Nested Table Here--->
<table width="100" style="margin-left:15" table  cellspacing="5" align="left" valign="TOP" nowrap>

<tr align="CENTER" bgcolor="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF">

<td rowspan="4" align="CENTER" valign="TOP">

<center>
<div class="fb-share-button" data-href="http://www.yogamerge.com/classpages/nikkanadia/restorative-flow.php" data-layout="button_count"></div><br><br><br></div>
<center>
    



</TD></tr>


</table> 

<table width="75" style="margin-right:0" table  cellspacing="5" align="right" valign="TOP" nowrap>

<tr align="CENTER" bgcolor="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF">

<td rowspan="4" align="CENTER" valign="TOP">

<center>
<div align="right"><a href="https://twitter.com/share" class="twitter-share-button" data-via="yogamerge" data-hashtags="yoga">Tweet</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');</script><br><br><br></div>
<center>
    
</TD></tr>


</table>
</td>
</tr>
</table>
<table width="950">
<tr>
<td>
<!----Insert Nested Table Here---->
<table width="950" style="margin-left:0" table  cellspacing="5" align="left" valign="TOP" nowrap>

<tr align="Left">

<td  nowrap><font face="Verdana, Arial, Helvetica, sans-serif"><b>Style: </b>Restorative Flow</td>

<td  nowrap>

</td>

<td nowrap><font face="Verdana, Arial, Helvetica, sans-serif"><b>LENGTH: </b>38 MIN.</td>

<td nowrap> <font face="Verdana, Arial, Helvetica, sans-serif"><b>Media: </b>MP4-H264</TD>

</tr>

</TR>

<tr>

<td colspan="3" class="desc" width="400"><font face="Verdana, Arial, Helvetica, sans-serif"><b>Instructor: </b>Nikka Nadia</TD>
<TD noWrap><font face="Verdana, Arial, Helvetica, sans-serif"><B>HD: </B>1920 X 1080</TD></TR>

<tr><td width="1100" colspan="3" class="desc"><font face="Verdana, Arial, Helvetica, sans-serif"><b>Level: </b>Level 1 (Beginner)<A HREF="javascript:new_window('http://www.yogamerge.com/classes/nikkanadia/restorative-flow/restorative-flow-caps.htm')"><b>(Photos)</b></a><P><font color="000000" font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
                                     If you're looking to slow your pace but still keep moving, then Nikka's Laid Back Restorative Flow may just hit
the spot! Many of us may find a true restoative class to be a little too slow paced, this class will offer a nice mix of movement and restorative postures. Nikka will serve up a little flow, twists, stretches and restorative
poses. This sequence is well suited for the beginner student. Needed props include two blocks and a blanket or towel. Poses include Sukhasana (Easy Pose), Marjaiasana (Cat Pose), Bitilasana (Cow Pose), Low Lunge, 
  Paschimottanasana (Seated Forward Fold), Uttana Shishosana (Puppy Pose) and more. As always practice safely. Enjoy!<P>
 
 <b>Note: This class is available as a stream or download via a site subscription. You may also purchase a Monthly Subscription to the Yoga|Merge Roku Channel in order to stream and watch
 on your TV. The class can also be purchased as a Download To Own product by adding it to your shopping cart.</b><P>

                                      
</td>

<td align="center">

<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
      <input type="hidden" name="add" value="1">
      <input type="hidden" name="cmd" value="_cart">
      <input type="hidden" name="business" value="info@yogamerge.com">
      <input type="hidden" name="item_name" value="Nikka's Laid Back Restorative Flow">
      <input type="hidden" name="item_number" value="130">
      <input type="hidden" name="amount" value="4.95">
      <input type="hidden" name="currency_code" value="USD">
      <input type="hidden" name="return" value="http://www.yogamerge.com/linklokipnret.php">
<input type="hidden" name="notify_url" value="http://www.yogamerge.com/linklokipn.php">
<input type="hidden" name="cbt" value="Return To YogaMerge For Download Links">
<input type="hidden" name="vibracart_pagelink" value="http://www.yogamerge.com/classpages/nikkanadia/restorative-flow.php">
      <input type="image" src="http://www.yogamerge.com/images/add_to_cart.jpg" style="padding:1px;border:thin solid black;" alt="Add to cart">
      </form>

</tr>

</table>
</td>
</tr>
</table>


<br>
<br>

<H1>Browse More Classes With Nikka Nadia</H1>


<?php $category = "nikka-nadia"; // name of category to load 
      include("http://www.yogamerge.com/includes/nikka-nadia-classes.php");?>

<center>
<div class="fb-comments" data-href="http://www.yogamerge.com/classpages/nikkanadia/restorative-flow.php" data-numposts="5" data-colorscheme="light"></div></center>

<br>

<br>



<script type="text/javascript">
 var gaJsHost=(("https:"==document.location.protocol)?"https://ssl.":"http://www.");
 document.write(unescape("%3Cscript src='"+gaJsHost+
   "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
 </script>
 <script type="text/javascript">
 var ejGATracker = _gat._getTracker("UA-44365450-1");
 ejGATracker._setDomainName("none");
 ejGATracker._setAllowLinker(true);
 ejGATracker._trackPageview();
 </script>
 
 <script language="javascript" type="text/javascript">
startcart()
</script> 

</body>
</html>


Hoping to get a little guidance with the below idea.

I created the below page, it has a php include statement that's pulling the additional yoga classes(records) at the bottom of the page from my CMS.

http://www.yogamerge.com/classpages/nikkanadia/restorative-flow-test.php

I just need to filter them so that it doesn't display all records. In this case, I would want to display all records for instructor Nikka Nadia. I would link to those records with this link, http://www.yogamerge.com/online-yoga-classes.php?categories_keyword=nikka-nadia

How would I setup the below php to only display the records for Nikka Nadia?

I spoke briefly with Ross about this, I seem to need to use a php request statement somehow, $_request

Thanks much, any help would be appreciated!

Kent

Here's the page code that my include statement displays on restorative-flow-test.php to show the list of yoga classes, it currently displays every record -

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

// load viewer library
$libraryPath = 'cmsb/lib/viewer_functions.php';
$dirsToCheck = array('/web/sites/greywood/yogamerge.com/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records from 'all_classes'
list($all_classesRecords, $all_classesMetaData) = getRecords(array(
'tableName' => 'all_classes',
'perPage' => '10',
'loadUploads' => true,
'allowSearch' => true,
));

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style>
</style>

<TITLE></TITLE>

<script language="JavaScript">
<!--//BEGIN Script
function new_window(url) {

link = window.open(url,"Link","toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=0,resizable=0,width=750,height=675,left=80,top=180");

}
//END Script-->
</script>

</head>

<body font face="Verdana, Arial, Helvetica, sans-serif" size="2" text="#000000" link="#000000">

<?php foreach ($all_classesRecords as $record): ?>


<table width="950" table cellspacing="5" valign="TOP" nowrap>

<tr align="CENTER" bgcolor="#000000" link="#FFFFFF" vlink="#FFFFFF">

<Td><font color="white" font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Class</b></Td><td width="950" colspan="3"><b><font color="white" font face="Verdana, Arial, Helvetica, sans-serif" size="2"><?php echo htmlencode($record['title']) ?></b></td></a>

<TD><font color="white" font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b><?php echo htmlencode($record['download_price']) ?></b></TD></tr>

<tr>

<td rowspan="4" align="CENTER" valign="TOP">

<a href="<?php echo htmlencode($record['preview_link']) ?>"><?php echo $record['thumb']; ?><font face="Verdana, Arial, Helvetica, sans-serif" font size="2" font color="000000" link="#FFFFFF" vlink="#FFFFFF"><B>PREVIEW</B></a><P>
</TD>

</TD></tr>

<tr>

<td nowrap><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Style: </b><?php echo htmlencode($record['style']) ?></td>

<td nowrap>

</td>

<td nowrap><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Length: </b><?php echo htmlencode($record['class_length']) ?></td>

<td nowrap> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Media: </b><?php echo htmlencode($record['media']) ?></TD>

</tr>

</TR>

<tr>

<td colspan="3" class="desc" width="400"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Instructor: </b><?php echo htmlencode($record['instructor']) ?></TD>
<TD noWrap><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>HD: </b><?php echo htmlencode($record['format']) ?></TD></TR>

<tr><td width="1100" colspan="3" class="desc"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Level: </b><?php echo htmlencode($record['class_level']) ?>
<?php echo htmlencode($record['description']) ?><P>

</td>

<td align="center">

<?php echo $record['add_to_cart']; ?><P>

</tr>

</table>

<?php endforeach ?>

<?php if (!$all_classesRecords): ?>
No records were found!<br/><br/>
<?php endif ?>

<br>
<br>

</body>
</html>