mysql query within a block

Comments

• admin

  November 2012 edited 6:20PM

  Does something like this work?
  {$domains= fuel_model('news',array(find='all' limit=1 where='star > 3'))}
  
  Are you using 0.93 or 1.0? If 0.93, there have been a couple changes to the php_to_template_syntax function in the MY_string_helper for 1.0 to help with the conversion of php syntax to the templating syntax. You can put in the following and save it and it should be converted:
  {$domains= fuel_model('domains',array('find'=>'all','limit'=>$topdomains_limit,'where'=> 'star>3'))}
  
  If you are still having trouble, does the query need to be in the block or can the result of the query be passed to the block in your layout with the 'var' parameter?
• najmphp

  November 2012 edited 6:20PM

  using 0.93;
  {$domains= fuel_model('news',array(find='all' limit=1 where='star > 3'))}
  worked fine.
  ---------------------
  but its logic looks like strange, is there any source to learn this kind of templating ?
  thank you
• admin

  November 2012 edited November 2012

  FUEL uses the Dwoo templating engine:
  dwoo.org
  http://www.getfuelcms.com/user_guide/parsing
  http://www.getfuelcms.com/user_guide/parsing/parsing_examples