Displaying records

15 posts by 2 authors in: Forums > CMS Builder
Last Post: April 20, 2011   (RSS)

Re: [design9] Displaying records

By Jason - April 20, 2011

Hi,

If you have the 2 separate queries, you'll need to use 2 separate foreach loops to output them.

Does this help? Are you encountering any errors?
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By design9 - April 20, 2011

Yes, I have two foreach loops but I am missing something. Can you take a look at the code to see? It is attached.

Thanks!

~A
Attachments:

test2_002.php 52K

Re: [design9] Displaying records

By Jason - April 20, 2011

Hi,

I think the issue was that our query is inside an if statement, but I don't think that if statement ever gets executed, instead, try this up near the top:

list($urgentcare_listRecords, $urgentcare_listMetaData) = getRecords(array(
'tableName' => 'urgentcare_list',
'where' => "pre_listing = '0'",
'perPage' => 100,
));

list($premium_listRecords, $premium_listMetaData) = getRecords(array(
'tableName' => 'urgentcare_list',
'where' => "pre_listing = '1'",
'perPage' => 100,
));

You can then use these 2 record sets for your two foreach loops.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By design9 - April 20, 2011

Thanks so much Jason...that works perfectly!

April