Is there a way I can pick and choose which records to display in which part of my page?  I dont want to use a 'where' statement in my header because i want to load all records but only display certain ones.

so instead of using a foreach:

<?php foreach ($our_teamRecords as $record): ?>
Record Number: <?php echo htmlencode($record['num']) ?><br/>
Title: <?php echo htmlencode($record['title']) ?><br/>

I would like to say something like "if recordnum = 1, display title"

function liStyle($category) {
if ($category['depth'] == 0) { return ""; }

if ($category['depth'] == 1 && $category['_isSelectedBranch']) { return ""; }
if ($category['_isSelected'] || $category['_isChildSelected'] || $category['_isParentSelected'] || $category['_isSiblingSelected']) { return ""; }

return " style = 'display:none;' ";
}

              I would like to only include records that have been created in the past 45 days.  What can I add to the clause below to do that?

'where'       => 'date>=DATE(NOW())',

       I am trying to upload a 9 mb file, but im gettin an error.  At first, when i tried to upload it, it told me it was too big.  I then went in and changed my upload max to unlimited.  now im getting the following error: http://i.imm.io/1fU6w.png

I was able to add a field for "state" but I can't figure out how to give the user a dropdown list, instead of free text.  As of now, both are there, but  I want only the drop down menu to be there, and not the text input.

I have a dynamic page of FAQ's on my site.  The page looks into the database and shows the visitor all the FAQ's for the category they selected.  how do i add a button for the visitors to generate an email that contains a specific FAQ.  I can't use a simple "mailto" link because most of my visitors to not have default email applications (outlook, groupwise, etc) on their PC's. I basically want the email to be generated from my server and just prompt the visitor for a recipient's email address. 

        When testing the "password reset" functionality, I noticed that it is broken.  In the Email it generates, the URL that is displayed is correct, but the URL that it brings up when clicked is not.  It's really bizarre because if you look at the php, they are asking for the same field.  I have included a screen shot which should make more sense than my text. 

How can i only load records that have a date that is after the current date (today's date).

// load records from 'code_updates'
list($code_updatesRecords, $code_updatesMetaData) = getRecords(array(
'tableName' => 'code_updates',
'where' => date > 'current date,

));