Displaying records

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

Archived
Reply
Reply

By design9 - April 20, 2011

Do I need to update some of the other code on the page? It is not working for me.

Thanks!

~A

Re: [design9] Displaying records

Archived
Reply
Reply

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/

Archived
Reply
Reply

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

Archived
Reply
Reply

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

Archived
Reply
Reply

By design9 - April 20, 2011

Thanks so much Jason...that works perfectly!

April