ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Query not returning expected results

April 14, 2012 6:38am

Subscribe [2]
  • #1 / Apr 14, 2012 6:38am

    Scott Boyde

    208 posts

    I have the following query and just noticed is not returning the expected results.

    {exp:query sql='SELECT cat_id FROM exp_categories WHERE cat_url_title = "{segment_4}"' }
       {cat_id}
       {embed="fixtures/.weekly_fixtures" catnum="{cat_id}&" start="<?php echo $start_time; ?>" stop="<?php echo $end_time; ?>"}
      {/exp:query}

    Should actually return two cat_id but instead it is returning 1.  If I run the query directly in my phpmyadmin it returns the expected results.

  • #2 / Apr 15, 2012 9:05pm

    Man With A Peg

    124 posts

    {cat_id} is not printing two values? I ask because $start_time and $end_time look like possible filters employed by fixtures/.weekly_fixtures.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases