Show Random Items from Multiple Sections
9 posts by 2 authors in: Forums > CMS Builder
Last Post: September 26, 2008 (RSS)
By zip222 - September 26, 2008
I tried using a random word generator pulling that pulled from a list of the 5 sections. I then tried to use that variable throughout the generated code, but I couldn't get that to work. Anyone have any ideas?
Re: [jdancisin] Show Random Items from Multiple Sections
To recap my understanding of what you tried:
1. Pull one random section name from a list of sections names.
2. Use a variable to input that section name into your code that pulls the project to be displayed.
Would you mind posting some of the code you used when you tried this method?
An alternative might be to keep all the projects in one section, but use a drop down list (or other selection device) of 'project categories' to specify to which 'project category' the individual project belongs. Then use that variable in your single randomization statement. This would have the added benefit of making it easy to change a 'project category' for an individual project if you later decide to do so.
Jim
Websites That Work
Re: [Mr Jim] Show Random Items from Multiple Sections
By zip222 - September 26, 2008 - edited: October 29, 2008
<?php
$filename="words.txt"; // grabs list of words from separate file - words match to section names.
$randomsections=file($filename);
shuffle($randomsections);
$randomsection=$randomsections[0];
require_once "/data/18/1/160/140/1649792/user/1778874/htdocs/cmsAdmin/lib/viewer_functions.php";
list($projectRecords, $projectMetaData) = getRecords(array(
'tableName' => '$randomsection', // this part doesn't work - not sure how I should write this
'allowSearch' => '0',
'where' => 'feature=0',
));
?>note: "$project" is not actually the title of one of my sections. I changed it to this generic title. The section titles are "branding, strategy, interactive, design, and investor"
Here is the page mockup, sans CMSB, in case its helpful:
[removed url]
Re: [jdancisin] Show Random Items from Multiple Sections
list($projectRecords, $projectMetaData) = getRecords(array(
'tableName' => $randomsection,
'allowSearch' => '0',
'where' => 'feature = 0',
since you're just pulling one section, you might want to also include:
'limit' => '1',
Hope this helps.
Jim
Websites That Work
Re: [Mr Jim] Show Random Items from Multiple Sections
By zip222 - September 26, 2008
getRecords(interactive ): Couldn't load schema for 'interactive '!The problem is that its inserting a space at the end of the section title. I think is happening because there is a return after each section name in the external file (words.txt). Is there a another method to provide the section names to the randomizer so that it doesn't add the space at the end of each? It doesn't need to come from an external file - that is just the way I found when I did a search.
Re: [jdancisin] Show Random Items from Multiple Sections
Before you drive yourself nuts, make sure that you are using a plain text editor when you create your external .txt file. There's probably a setting that will allow you to view invisible characters in the file. Make sure that the only thing at the end of each word is a UNIX line ending... I'm assuming that you're on a Unix server.
With most text editors you can set the type of line endings that they insert into the file.
Then it should work.
Jim
Websites That Work
Re: [Mr Jim] Show Random Items from Multiple Sections
By zip222 - September 26, 2008
I am using TextEdit on a Mac, saving in the TXT format. I am on a Unix server.
Re: [jdancisin] Show Random Items from Multiple Sections
By zip222 - September 26, 2008 - edited: October 29, 2008
$section[1] = "strategy";
$section[2] = "branding";
$section[3] = "interactive";
$section[4] = "design";
$section[5] = "investor";
$random_select = rand(1, 5);
$randomsection = $section[$random_select];works now:
[removed url]
Thanks for your help!
Re: [jdancisin] Show Random Items from Multiple Sections
Jim
Websites That Work