Ordering by Multiple Value Lists
23 posts by 4 authors in: Forums > CMS Builder
Last Post: December 17, 2010 (RSS)
By Chris - December 16, 2010 - edited: December 16, 2010
Hi studio-a,
Would something like this work for you?
Please let me know if you have any questions.
Would something like this work for you?
<?php
list($attractions_categoriesRecords, $attractions_categoriesMetaData) = getRecords(array(
'tableName' => 'attractions_categories',
'perPage' => '3',
));
?>
...
<?php foreach ($attractions_categoriesRecords as $category): ?>
<h2>Category: <?php echo htmlspecialchars($category['title']); ?></h2>
<?php
list($local_attractionsRecords, ) = getRecords(array(
'tableName' => 'attractions',
'where' => "category LIKE '%\t" . mysql_escape($category['title']) . "\t%'"
));
?>
<ul>
<?php foreach ($local_attractionsRecords as $attraction): ?>
<li><?php echo htmlspecialchars($attraction['name']); ?></li>
<?php endforeach ?>
</ul>
<?php endforeach ?>
<!-- add pagination links using $attractions_categoriesMetaData -->Please let me know if you have any questions.
All the best,
Chris
Chris
Re: [chris] Ordering by Multiple Value Lists
Hi Chris,
Thanks for your input and time. We will create a test page removing all of the Code Jason recommended and try this new code.
For the sake of this tutorial thread, it appears your approach is completely different than the code Jason began the thread topic with, is this correct?
Based on your code, the direction for this solution would be to create a special MySQL query when pulling the records (hence grouping the items which have the same category). Whereas, Jason's method was to use arrays within the PHP to group the items with the same category, is this correct?
We will let you know our efforts with implementing the code and to assist the thread's topic.
Thanks again for your help. You guys really do supply great support!
studio-a
Thanks for your input and time. We will create a test page removing all of the Code Jason recommended and try this new code.
For the sake of this tutorial thread, it appears your approach is completely different than the code Jason began the thread topic with, is this correct?
Based on your code, the direction for this solution would be to create a special MySQL query when pulling the records (hence grouping the items which have the same category). Whereas, Jason's method was to use arrays within the PHP to group the items with the same category, is this correct?
We will let you know our efforts with implementing the code and to assist the thread's topic.
Thanks again for your help. You guys really do supply great support!
studio-a
By Chris - December 17, 2010 - edited: December 17, 2010
Hi studio-a,
Yes, this approach is completely different. The method that Jason suggested is more efficient when displaying all the categories on one page.
Please let me know if you have any questions.
Yes, this approach is completely different. The method that Jason suggested is more efficient when displaying all the categories on one page.
Please let me know if you have any questions.
All the best,
Chris
Chris